| Author |
Message
|
| abebbington |
 Posted: Tue May 08, 2007 9:33 am Post subject: calling oracle stored procedure from ESQL using CALL hangs |
 |
|
Newbie
Joined: 08 May 2007
Posts: 3
|
Hello please can anybody help?
I am calling an oracle stored procedure using CALL and it hangs. However, when I use PASSTHRU to call the same stored procedure it can correctly call the stored procedure which seems to rule out conectivity issues.
I have spent alot of time checking datasource, odbc.ini etc and am sure it is all set up correctly. Has anybody experienced similar difficulties.
I am using WBIMB V5 CSD09
Many thanks |
|
| Back to top |
|
 |
| JT |
| Posted: Tue May 08, 2007 11:41 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| You might consider activating an ODBC trace for more information. |
|
| Back to top |
|
|
| abebbington |
| Posted: Tue May 08, 2007 2:09 pm Post subject: |
|
|
Newbie
Joined: 08 May 2007
Posts: 3
|
Many thanks.
yes I did activate an ODBC trace but could find no obvious errors. The trace file is rather large so do not want to post large chucks of it. is there any specific errors I could look for? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 08, 2007 3:51 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You should look for when the CALL starts.
Then you should see what comes next, if anything.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| abebbington |
| Posted: Wed May 09, 2007 8:40 am Post subject: |
|
|
Newbie
Joined: 08 May 2007
Posts: 3
|
Many thanks for the suggestions.
The problem has been tracked down to passing a parameter type BLOB into the stored procedure. If NULL is passed to the stored procedure for the BLOB type the call hangs. If the BLOB is non NULL then the call works fine.
I assume that there may be a potential mapping problem between broker NULL BLOB to Oracle NULL BLOB in that it fails to return. Whilst I do not believe we have resolved the problem, fortunately the project has now removed BLOB types from all stored procedure interfaces. |
|
| Back to top |
|
|
|
|
