Hey,
Please send me the DDL script.
Also, Let me know if you have converted stored procedure in SQL to Oracle.
Please let me how would do following stuff for conversion as it mentions some of the differences from SQL and Oracle.
| Replace
DTS |
| Call SP with
cursor to read data |
| Temp tables |
| Table
variables |
| Data Types |
| Cursor for
select query |
| Locking of
tables for multithreading |
| Built in
functions |
| Update
queries with Join |
| Insert data with Identity key using named sequence of the
respective table |
| Identity columns to be chenged to sequence |
| Can not select data from table on which trigger is written |
| Other Syntax changes in loop, cursor , variable assignment,
statement termination with semicolon |
| isnull function can be removed if it just used to check
"". As null and "" are same in oracle |
| handling output of multiple select statements from SP |
| Dynamic SQL statements |
Please reply me on
viraje@winsoftech.com
Waiting for your scripts....
Thanks & Regards,
Viraj V. Edgaonkar.