Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORA-00942 in SQL-Workshop

TobiPJul 2 2012 — edited Jul 3 2012
Greetings!

I want to populate a table with values partially from another table (1:1-relationship) with an INSERT ALL INTO-Statement:

INSERT ALL INTO
tbl_MAuthentifizierung (id_mitgl, logname) values (id_mitgl, "name", 'schach')
SELECT id_mitgl, substr(vorname,1,2)||substr(nachname,1,3) "name"
FROM TBL_MITGLIEDER;

Now, when I run this statement in SQL-Developer (on another schema), it works. But when I try to run in in APEX-SQL-Workshop (v 4.1.1) in the command-line, I get the error-message:

'ORA-00942: table or view does not exist'

... although I copied the names over from the Object-Browser.

How can I solve this?

I could do this in SQL-Developer, however I have another promlem here, which I hope you could help me with, too:
For my new project I set up a new workspace in APEX. Now I can't set up a conection to that from SQL-Developer... (I'm still quite new to all of this)
In the dialog for a new connection, as I understand, the connection-name you can select yourself, then I'm getting insecure: the username is the name of the scheme, and the password is the password, you asigned to the APEX-workspace-developer? Or which one? Because, when I want to set up a new connection there, I always get the error-message:
ORA-01017: invalid user/password; logon denied

Thanks in advance for your help, with best regards
Tobi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2012
Added on Jul 2 2012
6 comments
559 views