Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Create Package Body with ODBC

Re: Create Package Body with ODBC

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Mon, 27 Sep 2004 19:40:49 +0200
Message-ID: <h2kgl0lkfu1dpe9ip18qpq8johlh7u5k70@4ax.com>


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
Received on Mon Sep 27 2004 - 12:40:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US