Home » SQL & PL/SQL » SQL & PL/SQL » SQL*Loader-925: Error while parsing a cursor (via ocisq3)
SQL*Loader-925: Error while parsing a cursor (via ocisq3) [message #167892] Mon, 17 April 2006 15:18 Go to next message
davidro
Messages: 1
Registered: April 2006
Location: Toronto
Junior Member

I'm sure some folks have encountered this error already however, I cannot seem to get the correct solution. Tried the sample codes in this forums and still getting the same error.

Am using SQL Loader via Toad as it is our company's application.

Any help will be much appreciated. Thx.

Below is the actual log


SQL*Loader: Release 7.3.2.2.0 - Production on Mon Apr 17 15:26:04 2006

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

Control File: C:\confile.ctl
Data File: C:\MarksDiet.Dat
Bad File: C:\MarksDiet.bad
Discard File: C:\MarksDiet.dsc
(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 65024 bytes
Continuation: none specified
Path used: Conventional

Table "MARKSFAVORITEFOODS", loaded from every logical record.
Insert option in effect for this table: INSERT

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
NAME FIRST * , O(') CHARACTER
RANK NEXT * WHT O(') CHARACTER

SQL*Loader-925: Error while parsing a cursor (via ocisq3)
ORA-00942: table or view does not exist


Run began on Mon Apr 17 15:26:04 2006
Run ended on Mon Apr 17 15:26:05 2006

Elapsed time was: 00:00:00.98
CPU time was: 00:00:00.15 (May not include ORACLE CPU time)
Re: SQL*Loader-925: Error while parsing a cursor (via ocisq3) [message #167894 is a reply to message #167892] Mon, 17 April 2006 18:43 Go to previous message
markmal
Messages: 113
Registered: April 2006
Location: Toronto, Canada
Senior Member
questions first:

1. did you try to run SQL*Loader from command line, not from TOAD? Is error the same?
2. Your SQL*Loader is v7.3, what is your Oracle DB server version?
3. (stupid question) Have you made sure that user you connect with SQL*Loader has access to a table MARKSFAVORITEFOODS? May be you need <SCHEMA>.MARKSFAVORITEFOODS specification in ctl?

[Updated on: Mon, 17 April 2006 18:45]

Report message to a moderator

Previous Topic: Database name and Username in the same line
Next Topic: Dups on Parent child relationship
Goto Forum:
  


Current Time: Sun Sep 14 23:47:41 CDT 2014

Total time taken to generate the page: 0.09784 seconds