calling stored procedure inside a insert statement

[joemonvarghese]

hi i am converting stored procedures in sql server 2005 to oracle 8i. In one of the procedure they are using an insert statement which calls another stored procedure.. how can i convert this to oracle 8i.. eg; insert into table1 exec test_procedure

[gauthee]

I have a feeling that you cannot execute Stored Procedure in DML statements though functions can be used. Am i wrong?

Gautham

[andyharman]

Possibly return a cursor in the stored procedure, then iterate over that cursor to insert each record. You may get more joy from a more Oracle-specific forum.