Re: PL/SQL - help

Manjula Krishnan wrote:
>
> Can someone tell me what is wrong with my procedure :
>
> create or replace procedure test
> (keywd1 varchar2 , join1 varchar2 , keywd2 varchar2) as
> kcursor integer;
>
> begin
> kcursor := dbms_sql.open_cursor;
> dbms_sql.parse(kcursor, 'SELECT PATHNAME, DESCR, ASC_NUM FROM
> POMPEII, KEYWORD WHERE KEYWORD.PICTURE = POMPEII.ASC_NUM AND
> LOWER(KEYWORDS.KEYWRDS) = LOWER(' || keywd1 ||' )' ||
> join1 || 'LOWER(KEYWORDS.KEYWRDS) = LOWER(' || keywd2 || ' )',
> dbms_sql.v7);
> dbms_sql.close_cursor(kcursor);
> end;
>
> --- It compiles successfully. But, gives me the following errors at
> runtime.
>
> SQL> execute test('black', 'and' , 'figure');
> begin test('black', 'and' , 'figure'); end;
>
> *
> ERROR at line 1:
> ORA-00904: invalid column name
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
> ORA-06512: at "SYS.DBMS_SQL", line 25
> ORA-06512: at "CLSWORKER.TEST", line 8
> ORA-06512: at line 1
>
> Thanks,
>
> Manjula

Table keyword is refered as keywords in keywords.keywrds. Received on Sat Aug 02 1997 - 00:00:00 CEST