PL/SQL Question

From: Manjula Krishnan <krishnan_at_mailhost.tcs.tulane.edu>
Date: 1997/07/31
Message-ID: <33E0EFE5.4055@mailhost.tcs.tulane.edu>#1/1

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 Received on Thu Jul 31 1997 - 00:00:00 CDT