Dear all,
I am trying to construct the following PL/SQL block. When I run it I always get an 0RA-1001 error. May you please help me
Environment
Oracle 8.1.7.0
O/S W2K Sp3
declare
l_cursor integer := dbms_sql.open_cursor;
output utl_file.file_type;
cursor lnklst_cur is
select db_link lnk from dba_db_links;
lala varchar2(300);
begin
for lnklst_rec in lnklst_cur loop
output := utl_file.fopen( 'c:\', lnklst_rec.lnk||'_tablespace_healthcheck_20030213.slk', 'w',
lala := ' select tablespace_name from dba_tablespaces@'||lnklst_rec.lnk;
utl_file.put_line(output , lala);
dbms_sql.parse( l_cursor,lala ,dbms_sql.native );
/*owa_sylk.show(
p_file => output ,
p_cursor => l_cursor,
p_sum_column =>
owa_sylk.owaSylkArray( 'N' ),
p_show_grid => 'YES' );*/
dbms_sql.close_cursor( l_cursor );
utl_file.fclose( output );
end loop;
end;
(DC07DB-SYSADM)>/
declare
*
ÓÖÁËÌÁ óôç ãñáììÞ 1:
ORA-01001: ìç áðïäåêôüò cursor
ORA-06512: óå "SYS.DBMS_SYS_SQL", ãñáììÞ 824
ORA-06512: óå "SYS.DBMS_SQL", ãñáììÞ 32
ORA-06512: óå ãñáììÞ 12
It seems that dbms_sql.parse cannot understand the statement.
Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email: [EMAIL PROTECTED]