Sign Up

Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In
Continue with Google
or use


Have an account? Sign In Now

Sign In

Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.

Sign Up Here
Continue with Google
or use

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask a question.

Continue with Google
or use

Forgot Password?

Need An Account, Sign Up Here

Sorry, you do not have permission to add post.

Continue with Google
or use

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Oraask Logo Oraask Logo
Sign InSign Up

Oraask

  • Write
    • Add A New Post
    • Ask A Question

Oraask Navigation

Search
Ask A Question

Mobile menu

Close
Ask A Question
  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
    • Oraask XML Formatter
    • Oraask JSON Formatter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials
Home/ Questions/Q 3873
Next
In Process

Oraask Latest Questions

Question
Alan
  • 0
  • 0
AlanExplorer
Asked: September 12, 20162016-09-12T10:37:21+03:00 2016-09-12T10:37:21+03:00In: Oracle Forms

How to pass date parameter to oracle reports from oracle forms

  • 0
  • 0

BELOW IS THE CODE AM USING:
Am getting the error:”There exist uncompiled objects in the report”

declare
v_rep varchar2(1000):='a';
v_rep_status varchar2(1000):='a';
v_url varchar2(1000):='';
rep_status VARCHAR2(100);
repid REPORT_OBJECT;
thelist paramlist;
begin
thelist := get_parameter_list('rep_paramlist'); 
if not id_null(thelist) then 
destroy_parameter_list(thelist); 
end if;
thelist := CREATE_PARAMETER_LIST('rep_paramlist');
ADD_PARAMETER(thelist, 'PARAMFORM',TEXT_PARAMETER,'NO');
ADD_PARAMETER(thelist, 'P_BASE',TEXT_PARAMETER,'4010');
ADD_PARAMETER(thelist, 'P_date',TEXT_PARAMETER,'01-SEP-2016');

repid := find_report_object('KAP_STMT');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,FILE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESNAME,'/orainst/orahome2/midtier/tools/web/test_area/dinesh8.PDF'); 
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rep_orapp-uat_ASR2midtier');
v_rep:=run_report_object(repid,thelist);
rep_status := REPORT_OBJECT_STATUS(v_rep); 
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') 
LOOP 
rep_status := report_object_status(v_rep); 
END LOOP; 
IF rep_status = 'FINISHED' THEN 
null;

show_message('Report Executed successfully');
ELSE 
show_message('Error while running report'); 
END IF;
end;
oracle reports
1
  • 1 1 Answer
  • 1k Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook

    Related Questions

    • Integrate this dialog fonts to work in Oracle forms 12c
    • calling report from formbuilder 6.0 in menu to run in web server
    • Repeat same previous record or item in oracle forms ?
    • How to to check old and new values for item in Oracle Form ?
    • How to validate phone number with specific format and fixed length ?

    1 Answer

    • Voted
    • Oldest
    • Recent
    1. Hassan AbdElrahman
      Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
      2016-09-12T22:10:18+03:00Added an answer on September 12, 2016 at 10:10 pm

      your code looking good but let me ask you some questions :
      1- is your report exists in the directory you provide it to your code ?
      2- is your report compiled and working fine itself ?
      then please share full error message and number with when this error is throwing.
      thanks.

        • 0
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp

    Leave an answer
    Cancel reply

    You must login to add an answer.

    Continue with Google
    or use

    Forgot Password?

    Need An Account, Sign Up Here
    Continue with Google

    Sidebar

    Adv 250x250

    Explore

    • Categories
    • Questions
      • New Questions
      • Trending Questions
      • Must read Questions
      • Hot Questions
    • Dev Tools
      • Online Compiler
      • Base64 Converter
      • Oraask XML Formatter
      • Oraask JSON Formatter
    • Wiki
      • SQL Tutorials
      • Java Tutorials
      • Python Tutorials
      • JavaScript Tutorials

    Footer

    Oraask

    About

    Oraask is a website for developers and software engineers who want to learn new skills, share their knowledge, and solve their coding problems. Oraask provides free content on various programming languages and topics, such as Oracle, Python, Java, etc. Oraask also allows users to ask questions and get answers from other members of the community.

    About Us

    • About Us
    • Contact Us

    Legal Stuff

    • Privacy Policy
    • Terms & Conditions

    Follow

    Oraask is licensed under CC BY-NC-SA 4.0Oraask CopyrightOraask CopyrightOraask CopyrightOraask Copyright

    © 2019 Oraask. All Rights Reserved
    With Love by Oraask.

    Insert/edit link

    Enter the destination URL

    Or link to existing content

      No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.