Re: dbms_sql.parse

The variable for the second form actually has to be declared as type dbms_sql.varchar2s, not your own local 'equivalent' definition.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Anders Eriksson wrote in message <36D87882.5AC7315A_at_knowledgepartner.com>...
>Hello!
>
>I have discovered that dbms_sql.parse have two different formats. When I
>use the first format the procedure works fine but when I try the other I
>can not get it to work. It seems like it still tries to use the first
>format and therefore is complaining about the wrong type of parameters.
>
>
>dbms_sql.parse( myCursor, sqlStatement, dbms_sql.native ); -- OKEY
>dbms_sql.parse( myCursor, sqlStatementTable, 1, 16, TRUE,
>dbms_sql.native ); -- Gives the folowing error
>
>LINE/COL ERROR
>--------
>-----------------------------------------------------------------
>43/3 PLS-00306: wrong number or types of arguments in call to
>'PARSE'
>43/3 PL/SQL: Statement ignored
>
>Where sqlStatementTable defined as:
>table of varchar2(256)
> index by binary_integer;
Received on Sun Feb 28 1999 - 02:14:35 CST