Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL in PL/SQL
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