Guest_imported
New member
- Jan 1, 1970
- 0
Converting SQL Server 7 (SQL7) to Oracle 8i.
SQL7 stor proc has following structure:
**************************
set nocount on
set ansi_warnings off
inserts...
updates...
set nocount off
Select .... From table1...
**************************
Crystal Report will allow linked stor proc to
do updates, inserts, etc, as long as begins with
"set nocount on...set ansi_warnings off" command
AND there is a Select/Recordset at the end of
the Stor Proc preceded by a "set nocount off"
Crystal will link to this Select... and report
on the resulting Recordset.
Q: Is there an equivalent way to do this in an
Oracle stor proc.?
SQL7 stor proc has following structure:
**************************
set nocount on
set ansi_warnings off
inserts...
updates...
set nocount off
Select .... From table1...
**************************
Crystal Report will allow linked stor proc to
do updates, inserts, etc, as long as begins with
"set nocount on...set ansi_warnings off" command
AND there is a Select/Recordset at the end of
the Stor Proc preceded by a "set nocount off"
Crystal will link to this Select... and report
on the resulting Recordset.
Q: Is there an equivalent way to do this in an
Oracle stor proc.?
