Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Load processes
Oracle Load processes [message #298784] Thu, 07 February 2008 12:34 Go to next message
Arcane
Messages: 7
Registered: December 2007
Location: Netherland
Junior Member
Hi,

Is oracle load processes means the process of loading the data to oracle tables. Or is this seprate terminolgy in oracle.

I have done good research but could not figure out anything.

Thanks in advance
Re: Oracle Load processes [message #298787 is a reply to message #298784] Thu, 07 February 2008 12:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
oracle load processes

What is this? Where did you find it? Post a link.

Regards
Michel
Re: Oracle Load processes [message #298790 is a reply to message #298787] Thu, 07 February 2008 13:06 Go to previous messageGo to next message
Arcane
Messages: 7
Registered: December 2007
Location: Netherland
Junior Member
Load Process has Failed: -1861 SQLERRM
Re: Oracle Load processes [message #298791 is a reply to message #298790] Thu, 07 February 2008 13:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which error 1861? When did you get it?
From error messages book:
Quote:
ORA-01861: literal does not match format string
Cause: Literals in the input must be the same length as literals in the format string (with the exception of leading whitespace). If the "FX" modifier has been toggled on, the literal must match exactly, with no extra whitespace.
Action: Correct the format string to match the literal.

Regards
Michel
Re: Oracle Load processes [message #298792 is a reply to message #298790] Thu, 07 February 2008 13:14 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
What's the betting that there is a WHEN OTHERS involved here somewhere?
Re: Oracle Load processes [message #298794 is a reply to message #298790] Thu, 07 February 2008 13:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
begin
dbms_output.put_line(sqlerrm(-1861));
end;
/

ORA-01861: literal does not match format string

Instruction traitée.
Re: Oracle Load processes [message #298795 is a reply to message #298792] Thu, 07 February 2008 13:18 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you are and this silly program just display its stupid "Load Process has Failed".

Regards
Michel
Previous Topic: Returning rows with a condition
Next Topic: update/replace in pl/sql block
Goto Forum:
  


Current Time: Sat Dec 03 01:23:40 CST 2016

Total time taken to generate the page: 0.11261 seconds