Re: ORA-00905 error in PL/SQL code

A few changes for you... See below:

Gennady wrote in message <3934160a$0$32021_at_fountain.mindlink.net>...
>Hello,
>I'm trying to execute the code:
>declare
>c2 number;
>d2 number;
>k number;

 ignore number;
>vin_table_name varchar2(30):='MYTABLE';
>begin
>dbms_output.enable;
>c2 := dbms_sql.open_cursor;

dbms_sql.parse(c2, 'select count(*) from '||vin_table_name,
dbms_sql.native);
dbms_sql.define_column(c2,1,k);

>d2:=dbms_sql.execute(c2);

ignore := dbms_sql.fetch_rows(c2);
dbms_sql.column_value(c2,1, k);

>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 Thu Jun 01 2000 - 00:00:00 CDT