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: 25571
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: insert with mutilple parameter
Next Topic: running multiple packages in database
Goto Forum:
  


Current Time: Sun Aug 20 12:29:33 CDT 2017

Total time taken to generate the page: 0.01081 seconds