Home » SQL & PL/SQL » SQL & PL/SQL » Manual table join error (Oracle XE 10g express edition, Windows XP Professional)
Manual table join error [message #332743] Wed, 09 July 2008 09:48 Go to next message
mbellamy
Messages: 4
Registered: July 2008
Junior Member
Hello,

I am a very new user of Oracle. I have figured out how to upload csv tables and do a manual join. However, when I tried to execute a second join, I get this error:

"column length cannot be null"

There are no column lengths less than 1 and no blank ones. I read the help documentation on manual joins but all it says is "follow the directions on the screen" so it hasn't been much help.

Thanks in advance for any and all responses,

- Megan
Re: Manual table join error [message #332746 is a reply to message #332743] Wed, 09 July 2008 10:04 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Since you did not actually show us what you did & what you have,
it is impossible for anyone to provide you with a solution.
Re: Manual table join error [message #332752 is a reply to message #332743] Wed, 09 July 2008 10:21 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The phrase 'follow the directions on the screen' leads me to believe that you are using some sort of GUI query builder.

So, in addition to not knowing the tables you're using, or the query that you'r having problems with, we also don't know the tool that you're using to build the query.

Re: Manual table join error [message #332764 is a reply to message #332752] Wed, 09 July 2008 10:38 Go to previous message
mbellamy
Messages: 4
Registered: July 2008
Junior Member
Thanks for the comments, they are well founded. I will do some more reading so I can better explain my problem.

Previous Topic: sql server query to oracle 10g query
Next Topic: Calling a Trigger from a Procedure.
Goto Forum:
  


Current Time: Sun Dec 11 00:04:48 CST 2016

Total time taken to generate the page: 0.15658 seconds