| Author |
Message
|
| shwetabh WMB |
 Posted: Thu Jul 28, 2016 11:33 am Post subject: Cannot find stored procedure on Oracle DB upgrade. |
 |
|
Novice
Joined: 15 Jul 2016
Posts: 23
|
Hi,
We have issue while calling stored procedure with no parameter from IIB on Oracle 12c.Proc was getting called and working fine in lower version of Oracle.On Oracle upgrade to 12c we are not able to call stored proc.Error is thrown stating stored procedure not found.However we are able to see proc in same package .
We tried adding one parameter to stored procedure and it worked fine.
On making stored proc call in sql editor(with or without parameter),it worked fine.
We have cross verified the packagename and proc name.It is correct and there is no difference.
Anyone faced similar issue? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Jul 28, 2016 12:17 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
What version of IIB?
We had some issues with Oracle 12c and were advised to move to v9.0.0.5. Apparently 12c isn't certified with IIB lower than that.
I don't know what specific APARs helped, and a PMR could probably obtain them, but the upgrade made all our problems go away.
("Fixed in the latest version" - who would have guessed it was technical advice and not a stall for more time?)
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| shwetabh WMB |
| Posted: Thu Jul 28, 2016 6:32 pm Post subject: |
|
|
Novice
Joined: 15 Jul 2016
Posts: 23
|
|
| Back to top |
|
|
| shwetabh WMB |
| Posted: Fri Jul 29, 2016 2:57 am Post subject: |
|
|
Novice
Joined: 15 Jul 2016
Posts: 23
|
V9005 is not helping  .Same issue persist with stored proc call. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jul 29, 2016 4:21 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| shwetabh WMB wrote: |
| V9005 is not helping .Same issue persist with stored proc call. |
But at least now you're not on a withdrawn fix pack. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| shwetabh WMB |
| Posted: Fri Jul 29, 2016 4:27 am Post subject: |
|
|
Novice
Joined: 15 Jul 2016
Posts: 23
|
| That's true .but still need to figure out the issue |
|
| Back to top |
|
|
|
|
