This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Oracle/OAS and the fly likes Oracle Procedure problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle Procedure problem" Watch "Oracle Procedure problem" New topic
Author

Oracle Procedure problem

balajee annamalai
Ranch Hand

Joined: May 09, 2007
Posts: 31
In oracle10g im creating a procedure in that i has a leftouter join which looks like "left outer join configusers.users" when i try to run this procedure Im getting an error on this abc.checkbook im in a different domain called bcd where this procedure actually running. Please help me on this it is very urgent
balajee annamalai
Ranch Hand

Joined: May 09, 2007
Posts: 31
please help i thought this is a frendly site and every one will help me?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30356
    
150

Balajee,
This is a friendly site!

First of all, you need to allow at least 24 hours for everyone to see your post. People are in different time zones throughout the world and many people log on once a day (at a minimum.) For specialized questions, there's also the possibility that people just don't know.

Now on to your question, are you able to run this query from the command line (rather than through the stored procedure) ? This will tell you if the problem is with the stored procedure or the query itself.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
Useally I see this type of error when there is a problem in the sql statement , wrong or missing qualifier on a column name. Difficult
to tell with the little code you provided.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Oracle Procedure problem