Re: DBMS_SQL.PARSE Question

On Wed, 25 Mar 1998 13:57:22 -0600, snapondba_at_hotmail.com wrote:

>I am having a bit of trouble trying to get the DBMS_SQL.PARSE procedure to
>work (using a statement longer that 255 chars) and I hope someone can assist.
>This is being run against a version 7.3.2.3 database. I am trying to use the
>form of the parse procedure which uses a PL/SQL table of varchar2's as the
>statement to be parsed. I continue to get the following error returned when I
>attempt to create the following procedure. I have tried the call to
>dbms_sql.parse the way it appears in the code below and also like the
>commented statement directly following it with the same error.
>
>HELP!
>
>Line 24: Pos 3: PLS-00306: wrong number or types of arguments in call to
>'PARSE' Line 24: Pos 3: PL/SQL: Statement ignored
>

[SNIP]
>
>Thanks in Advance,
>David C. Greene
>Database Administrator
>Enterprise Data Management
>Snap-on Tools Company

Hi David,

the version of DBMS_SQL.PARSE which takes a PL/SQL table of VARCHAR2 as input for the statement is available in Oracle8, but not in 7.x. You have to use the normal version with just one VARCHAR2 parameter for the statement.

HTH
Peter

-- 
Peter Schneider
peter.schneider_at_okay.net