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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL in PL/SQL

Re: Dynamic SQL in PL/SQL

From: Rudi Demeulenaere <rdm_at_mentor.spamnothanks.be>
Date: Thu, 30 Apr 1998 20:19:56 +0200
Message-ID: <3548C0CB.B41672C@mentor.spamnothanks.be>

Christian Scholz wrote:

> I have a problem with the DBMS_SQL Package in a PL/SQL Procedure.
> I try to generate a INSERT INTO statement and execute it with dynamic
> SQL.
> This works fine with a short statement. When I try to parse a long
> statement with DBMS_SQL.PARSE(... ); the Database throws an exeption.
> The sql error is -936.
> I tried to use an PL/SQL table as the parameter, too.

I used to have this when my execute-string was simply too short e.g....   ExecuteString varchar2(2000);
...
Also, passing on a pl/sql table will not work. It only accepts sql.

r u d i
(remove anti-spam measure from reply-address) Received on Thu Apr 30 1998 - 13:19:56 CDT

Original text of this message

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