Home » SQL & PL/SQL » SQL & PL/SQL » not Load PL/SQL in PROC (PROC ans Pl/SQL)
icon4.gif  not Load PL/SQL in PROC [message #352903] Fri, 10 October 2008 03:03 Go to next message
ejrivas
Messages: 5
Registered: October 2008
Junior Member
Good morning I have a case casper, I have several processes Pro * C. Pc containing a pl / sql between embedded EXEC SQL EXECUTE, and delimiters END-EXEC;

Something progran load that other in the pas loaded but not not load....

Well Compiling the correct procedure to check the pre compiler to Oracle FULL, sometimes I was not charging the pl / sql BB.DD in remote and do not run the pl, ie it is as if the loading to be executed oracle check it by somehow and do not charge, but does not return any errors.

Would there be any way of knowing why not load the pl / sql? is not a variable or log BB.DD that saved potential errors?

Thank you very much,

Javier greetings
Re: not Load PL/SQL in PROC [message #352922 is a reply to message #352903] Fri, 10 October 2008 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I started to not understand what you say with the following:
Quote:
Something progran load that other in the pas loaded but not not load....

I think some words are wrong, some are missing and some are too much. Not meaning to belittle you on your english (I make many mistakes) but when a threshold is exceeded (depending on each one english skill and mine is not so high), this becomes not understandable.

Regards
Michel

[Updated on: Fri, 10 October 2008 04:40]

Report message to a moderator

Re: not Load PL/SQL in PROC [message #352952 is a reply to message #352922] Fri, 10 October 2008 05:42 Go to previous messageGo to next message
ejrivas
Messages: 5
Registered: October 2008
Junior Member
i'm from spain and my english is bad, i try to said that the pl/sql embebed not execute
Re: not Load PL/SQL in PROC [message #352960 is a reply to message #352952] Fri, 10 October 2008 05:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But what does "not execute" means?
Is there any error?

By the way, at the bottom forum home page there is a Spanish forum where you can put your question in... spanish. Smile
Some of us know your language.

Regards
Michel
Re: not Load PL/SQL in PROC [message #352962 is a reply to message #352960] Fri, 10 October 2008 05:58 Go to previous messageGo to next message
ejrivas
Messages: 5
Registered: October 2008
Junior Member
no no any error, this is the questions i have a EXCEPTION
WHEN OTHERS THEN in the pl/SQL but when i esecute the proc Pl/sql it's execute in oracle
Re: not Load PL/SQL in PROC [message #352965 is a reply to message #352960] Fri, 10 October 2008 06:07 Go to previous messageGo to next message
ejrivas
Messages: 5
Registered: October 2008
Junior Member
ok ok thank you i will wrote there thank.
Re: not Load PL/SQL in PROC [message #352982 is a reply to message #352962] Fri, 10 October 2008 07:00 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to first REMOVE (or comment) any WHEN OTHERS clause.

Regards
Michel
Previous Topic: Maximum value
Next Topic: Confusions regarding the code
Goto Forum:
  


Current Time: Sat Dec 10 05:00:38 CST 2016

Total time taken to generate the page: 0.14684 seconds