how can i call an oracle function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can i call an oracle function?

given a project_no, i need to call the function:

ops$sqltime.pa_new_job_no_fn

which will return the next job_no

thanks in advance.
 
...

how can i call an oracle function?
Click to expand...

Did you try the answer I gave you the previous time you posted this
question?
given a project_no, i need to call the function:

ops$sqltime.pa_new_job_no_fn

which will return the next job_no
Click to expand...


In short, Oracle functions are called in the same way you call Oracle stored
procedures, but use named parameters, where the returning result is named
"RETURN_VALUE".

// Bjorn A
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to call an oracle function 12
How to call oracle function to get returned boolean type 2
exception when calling an oracle function 3
How to call an oracle function with a in C#. 4
oracle import- and export-commands are contained in which .dll fil 2
Using Excel to call Oracle Stored procedure. 1
return value from Oracle stored proc 2
calling oracle stored proc from .net 3

Back
Top