Hi!

Okay, I get your point.... Thanks for correcting me. Let me ask you this. I'm sort of new and so can use some advise.

Basically, I am converting a SQL Server stored proc. to oracle pl/sql. Here is the sql server one:

CREATE PROCEDURE InsertBlkHeader(@fkey int,@bSNum int,@bCount int,@fOffset int, @id int OUTPUT) AS
INSERT CallBlockHeader (pk_sourceFile, blockSerialNumber, blockCount,fileOffset)
VALUES(@fkey, @bSNum, @bCount, @fOffset)
Select @id = @@IDENTITY

In the above, when they do "select @id = @@identity", they are returning the value to the calling front-end program in Visual C++. I am trying to do the same thing in oracle. The @id is an output parameter.
Am i doing the right stuff in my stored proc. in PL/SQL or am i totally messing up?
Please advise.