Hi,
I have an Oracle procedure in a .sql file
sample proc:
--------------
create or replace procedure proc_chk()
as
begin
insert into tbl values(...);
commit;
other sql statements
....
end;
/
Now in data manager im trying to invoke this sql script using the SQLTERM comand as below:
SQLTERM ORACLE "usr/pss@servicename" -f"D:\chk_pro.sql"
It's failing with error as:
DM-SQT-0006 The remainder of the line is ignored.
can anybody help and let me know how to invok .sql scripts in SQL TERM and compile/create pl/sql procedures.
finally got a solution:
sample proc:
--------------
create or replace procedure proc_chk()
as
begin
insert into tbl values(...);
commit;
other sql statements
....
end;
/
should be changed as like this to get it compiled:
STATEMENT DML
<BEGINSQL>
create or replace procedure proc_chk()
as
begin
insert into tbl values(...);
commit;
other sql statements
....
end;
<ENDSQL>
Oracle statements need to put placed between
STATEMENT DML
<BEGINSQL>
....
<ENDSQL>
I hope it does give solution for those who r looking for it. :-)
If u have got any better/alternative way pls share.
Thanks - very useful info.
MF.