PL/SQL Proc compilation using SQLTERM

[LEO]

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.

[LEO]

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.

[MFGF]

Thanks - very useful info.

MF.