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
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 - 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
------------------------------ ---------- ----- ---- ---- ---------------------

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
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: SQL/PLSQL Query
Next Topic: checking multiple columns on a single row
Goto Forum:

Current Time: Mon Aug 21 14:55:27 CDT 2017

Total time taken to generate the page: 0.01676 seconds