Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
My application is not working now
i have converted the whole SQL database to Oracle 10 g
so now in almost every stored procedure this type of output cursor is automatically added because of this conversion
 
username IN VARCHAR2 DEFAULT NULL
passwrd IN VARCHAR2 DEFAULT NULL
A IN OUT SYS_REFCURSOR,
B IN OUT SYS_REFCURSOR,
C IN OUT SYS_REFCURSOR

 
last three are automatically added
 
so application is giving error number of parameter don't match
i can not modified all the page code, there are 200 page
 
is there any way to just modify these SP only
or any shortcut
 
Please help me.
Posted 7-May-12 4:51am
Comments
ryanb31 at 7-May-12 10:57am
   
A "shortcut" to get from SQL to Oracle? Not likely.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Start here[^]. You might find some of the links helpful.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 397
1 OriginalGriff 350
2 thatraja 205
3 Emre Ataseven 165
4 Shai Vashdi 150
0 Sergey Alexandrovich Kryukov 8,894
1 OriginalGriff 5,200
2 Peter Leow 3,955
3 Maciej Los 3,535
4 Abhinav S 3,208


Advertise | Privacy | Mobile
Web04 | 2.8.140415.2 | Last Updated 7 May 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid