| ORA-24344: success with compilation error [message #30796] |
Fri, 21 May 2004 09:36  |
SS
Messages: 46
Registered: November 2001
|
Member |
|
|
Package creates successfully. On execution, it throws the following error. It executes successfully also.
ORA-24344: success with compilation error
What may be reason?
ss
|
|
|
|
| Re: ORA-24344: success with compilation error [message #30798 is a reply to message #30796] |
Fri, 21 May 2004 09:55  |
Jon
Messages: 483
Registered: May 2001
|
Senior Member |
|
|
It may be that Oracle doesn't like you.
It may be that this is a right-wing plot.
It may be that this is a left-wing plot.
It may be that you are doing dynamic SQL and have a "/" embedded that it doesn't like.
It may be one of hundreds of other possibilities.
There are lots of possibilities...without specific examples, we would have to be mindreaders to help you.
|
|
|
|
| Re: ORA-24344: success with compilation error [message #30799 is a reply to message #30798] |
Fri, 21 May 2004 09:59 |
SS
Messages: 46
Registered: November 2001
|
Member |
|
|
It may be that you are doing dynamic SQL and have a "/" embedded that it doesn't like.
It is this one. I am using a hint /*+ hint */ inside a string to be executed immediately.
It was working before though, that is throwing me off.
Any way, what is the work around?
ss
|
|
|
|
| Re: ORA-24344: success with compilation error [message #30802 is a reply to message #30799] |
Fri, 21 May 2004 11:15 |
Jon
Messages: 483
Registered: May 2001
|
Senior Member |
|
|
I've think you've discounted the extremist conspiracies too easily...
Seriously, I was trying to get you to post the entire procedure and the results using cut and paste. I will be signing off shortly, but if you want someone else to help, I suggest you do that, anyway.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
