Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> ORA-00905 error in PL/SQL code

ORA-00905 error in PL/SQL code

From: Gennady <gennadyb_at_halcosoftware.com>
Date: 2000/05/30
Message-ID: <3934160a$0$32021@fountain.mindlink.net>#1/1

Hello,
I'm trying to execute the code:
declare
c2 number;
d2 number;
k number;
vin_table_name varchar2(30):='MYTABLE';
begin
dbms_output.enable;
c2 := dbms_sql.open_cursor;
dbms_sql.parse(c2, 'select count(*) into '||k||' from '||vin_table_name||'',dbms_sql.native);
d2:=dbms_sql.execute(c2);
dbms_output.put_line(k);
dbms_sql.close_cursor(c2);
end;

But I get error ORA-00905: missing keyword. Could you please give me a hint how to fix the problem? Thanks,
Gennady Received on Tue May 30 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US