Re: Create Package Body with ODBC

On 27 Sep 2004 01:28:27 -0700, hsauren_at_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 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

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