RE: HOW TO EXECUTE DELETE RECORD sucefylly .

Good Morning Marvin;

>> FECHA = :fec AND HORA = :hor
…
>> add two points

Ok… after reviewing the photos, I’m now under the impression I completely misunderstood the original question.

I thought the error you were receiving was directly related to executing the stored procedure.  As it turns out, now I understand what you wanted to do was extract the DELETE statement out of the stored procedure and run it stand alone as-is.

Now the error totally makes sense as well as the solution.

To answer your situation: yes, when you attempt to use parameters at the command line you need to tell the Oracle client (whether Toad, SQLPlus, SQL Developer, etc) that they are parameters.  The ":" character is usually used to denote bind variables.  You could also use the "&" character (this depends on if your "define" value is set to default or has been changed).

Roger S.

This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/