Re: Create Package Body with ODBC
Date: Mon, 27 Sep 2004 19:40:49 +0200
On 27 Sep 2004 01:28:27 -0700, hsauren_at_gruen-ag.de (Hans Sauren) wrote:
>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
>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
>Thanks for any idea,
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 DBAReceived on Mon Sep 27 2004 - 19:40:49 CEST