Re: Dynamic SQL in PL/SQL

From: <brendan_o'brien_at_wrightexpress.com>
Date: Thu, 23 Apr 1998 11:19:17 -0600
Message-ID: <6hnpm4$clf$1@nnrp1.dejanews.com>

I've never seen that particular error, but you should be using the reserved variable 'sqlerrm' in your exception |when others (printing 'sqlerrm' via dbms_output.put_line or htp.p or whatever). It's an invaluable thing and should be in every single procedure you write...

In article <353A7B23.941FE546_at_syskoplan.de>, Christian Scholz <christian.scholz_at_syskoplan.de> 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 work with an Oracle 7.3 Server running PL/SQL on the server.
> Are there known Problems with Dynamic SQL and long statements?
> What does the error mean?
> How can I get information about the errorcode from the system?
>
> I would be pleased about every help.
>
> Christian Scholz
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 23 1998 - 12:19:17 CDT