Hi
While i am trying to insert a table i am getting the following error:
ORA-00904: “USERNAME”: invalid identifier.
I cant see any of the tables.
But when i run a report from the same universe i am getting data.
The username to connect to the database is working fine whn i tried in the PL/SQl developer and i am able to see the tables there.
any clues why is it happening.
Thank You
Follower (BOB member since 2004-06-24)
Is your ODBC connection to Oracle set up with the same user id and password?
Did the ownership of the tables change? Ask your DBA, please.
Andreas 
(BOB member since 2002-06-20)
I was under the impression that You cannot “write” data into a database using WebI. How do you enable writing from WebI? OR is this an indirect effect of executing a Stored Procedure from BO?
JSanthanam 
(BOB member since 2003-12-17)
Given that this is in the Designer forum, Andreas and I assumed that Follower was trying to insert a table into the Designer schema…
Thanks MArk! That was a pretty lame question from my side. I should have known better!
JSanthanam 
(BOB member since 2003-12-17)