Re: dbms_sql.parse question

Wayne McKinney wrote in message <6pqn78$hb7$1_at_news0-alterdial.uu.net>...
>I'm trying to use the following statement in my Forms 5.0 form.
>
>DBMS_SQL.PARSE(source_cursor,
> 'SELECT EMP_NAME FROM EMP_TABLE',DBMS_SQL.native);
>
>In PL/SQL run from SQL*Plus, this statement runs just fine. When I try to
>place this same statement in a trigger, I get the error :
>
>Implementation Restriction: 'DBMS_SQL.NATIVE': Cannot directly access
remote
>package variable or cursor
>
>and the trigger won't compile at all.
>
>I tried researching this problem in the Usenet Oracle groups and came up
>with (form Forms 4.5) that this really was an implementation restriction.
>Forms 4.5 uses PL/SQL version 1 which doesn't allow for package variables
>like 'DBMS_SQL.NATIVE'. I'm not sure, though, if this applies to me. A
>quick trip to the Forms Buildler (Forms 5.0) 'About' box shows that PL/SQL
>version 2.3.4. The SQL*Plus I'm using is accessing an Oracle 8 server, so
>it's PL/SQL engine shows version 8.0.4.
>
>Steve Cosner (http://members.aol.com/stevec5088) suggested to use a '1' in
>place of 'DBMS_SQL.V7'. I tried this, and, even though the form compiled
>and the PARSE went through, the DBMS_SQL.EXECUTE failed in the form.
>
>What's wrong here?
>
>
>

Wayne,

We are still using 4.5 of forms. if you want to execute dynamic SQL in 4.5, you need to use the forms_ddl built-in. Check the on-line help for the package.

Shirley Burk
sburk_at_gte.net Received on Fri Jul 31 1998 - 02:37:39 CEST