Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How do i call Oracle function from Coldfusion

Posted on 2004-08-22
3
Medium Priority
?
392 Views
Last Modified: 2013-12-16
How do i call oracle function from Coldfusion using cfstoredproc.
Below is my oracle function:

FUNCTION Get_Load_Lock (pm_source IN VARCHAR2) RETURN BOOLEAN

IS
v_lock  SNDSV_REF_CODES.rv_high_value%TYPE;

BEGIN
    BEGIN
            SELECT rv_high_value INTO v_lock
            FROM SNDSV_REF_CODES
            WHERE rv_domain = 'E-EKSAIS'
            AND rv_type = 'CONTROL'
            AND rv_low_value = 'LOCK - '||pm_source
            AND record_status = 'E'
            FOR UPDATE OF rv_high_value NOWAIT;

            ROLLBACK;

      EXCEPTION WHEN OTHERS THEN
        v_lock := 'Y';
      END;

      IF v_lock = 'N' THEN
          RETURN TRUE;
      ELSE
          RETURN FALSE;
      END IF;

END Get_Load_Lock;

Note: pm_source = PAYMENT.
0
Comment
Question by:shakker
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 7

Accepted Solution

by:
suramsureshbabu earned 1000 total points
ID: 11867380
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Make the most of your online learning experience.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Introduction to Processes
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question