Skip to Main Content

SQL & PL/SQL

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!

Getting error "ORA-44004: invalid qualified SQL name" while using loadpsp

user_snehaAug 24 2012 — edited Jan 7 2013
Hi,

I used the below html file as test.psp and saved it on my desktop:

<html>
<head>
<title>Hello World</title>
</head>
<body>
<h1>Hello World.</h1>
</body>
</html>

When i tried to use the loadpsp command from cmd, I encountered the below error:

command:

D:\oracle\product\10.2.0\client_1\bin>loadpsp -replace -user xyz/xyz@xyz C:\Users\testuser\Desktop\test.psp

error:

ORA-20006: "C:\Users\testuser\Desktop\test.psp": compilation failed with the following errors.
ORA-44004: invalid qualified SQL name


Please advice what is that is incorrect above.

Edited by: user13491035 on Aug 24, 2012 12:09 AM

Edited by: user13491035 on Aug 24, 2012 12:10 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2013
Added on Aug 24 2012
5 comments
1,108 views