Re: PL/SQL - help

Seems like you may have got a glitch in the data dictionary for the procedural option. We have found that we sometimes have had to run some or all of the scripts referenced by catproc.sql. Have you upgraded the RDBMS and missed an upgrade .sql?

Anybody else got any ideas?

In article <33E0F246.20A3_at_mailhost.tcs.tulane.edu>, Manjula Krishnan <krishnan_at_mailhost.tcs.tulane.edu> writes
>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
 

-- 
Tom Cooke