Create Package Body with ODBC

[Hans Sauren]

Hi all,
we want to create a package body by sending a sql-statement with ODBC.
We use ODBC-Driver Version 8.01.07.810 with ORACLE-Database 8.1.7 and
9i. Now it seems that the length of the statement is restricted so
that we can't execute statement with more than approximate 9200
characters. But the function we want to create in the package body has
more characters.
Does anyone know if there is a length-restriction by executing
statements with ODBC? Can I switch the length and if yes where? Or is
it possible to create package bodies in an other way than in sending
one statement?
Thanks for any idea,

Hans Sauren

[Sybrand Bakker]

On 27 Sep 2004 01:28:27 -0700, hsauren@gruen-ag.de (Hans Sauren)
wrote:
Hi all,we want to create a package body by sending a sql-statement with ODBC.We use ODBC-Driver Version 8.01.07.810 with ORACLE-Database 8.1.7 and9i. Now it seems that the length of the statement is restricted sothat we can't execute statement with more than approximate 9200characters. But the function we want to create in the package body hasmore characters.Does anyone know if there is a length-restriction by executingstatements with ODBC? Can I switch the length and if yes where? Or isit possible to create package bodies in an other way than in sendingone statement?Thanks for any idea,Hans Sauren


I think one must question first why you need to create package bodies
on the fly using ODBC. This has definitely nothing to do with proper
database administration!


--
Sybrand Bakker, Senior Oracle DBA

[wario]

Skip ODBC and use SQLPLUS to create objects.

Wario