We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SP-0042 Error

GRChandrashekar
on
Medium Priority
3,469 Views
Last Modified: 2012-05-11
I am trying execute SQL file using command @c:\create.sql and I get the following ERROR.

SP2-0042: unknown command "ÿþC" - rest of line ignored.

In some of the forums, it was suggested to check the SQL file for errors but there are absolutely no errors. At least one command should execute. I have attached create.sql file.

In another forum, it was suggested to check glogin.sql but could not trace anything. glogin.sql
also attached

I thought problem in my PC but other PC also gives same error.



create.sql
glogin.sql
Comment
Watch Question

Author

Commented:
Well I did try this but no luck
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
No. I deleted entire file except the first crate sequence command. Still the same error

Commented:
I know this is not a solution, but can you try executing it from any other tool like SQL Developer, PL/SQL Developer or TOAD?

Commented:
thanks for accepting my comment.

Can you please let us know how did you remove the special character?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.