• Escalation module with Oracle 9i and Oracle Forms 6i

    We are developing customer care software working on Escalation Module. Here my system should generates an email to executive or technical head if complaint doesn't get resolved within 3-hrs. I'm using Oracle 9i and forms 6i as front end. I have two points to be discussed. If complaint occurs at...

    Firasha25 pointsBadges:
  • Call parameter from Oracle Reports 10g web.show_doc

    Here's the code:DECLARE rep_url varchar2(2000); BEGIN rep_url:='/reports/rwservlet?' ||'&report=c:testrpt10g.rdf' ||'&desformat=htmlcss&destype=cache' ||'&userid=stlexport/stlexpst@as'; WEB.SHOW_DOCUMENT(rep_url,'_blank'); END; It's running well but now I want the report's parameter...

    Superad35 pointsBadges:
  • Dear Carlos De Leon… Kindly help me out

    Hi, Dear Carlos De Leon, You have told me that I have to do that by saving the value of the parameter in the database and use it later when I need that. Can you please help me out how can I do that. We will have to pass as much parameters as the number of columns in the report. Can you please help...

    Cutejut10 pointsBadges:
  • LEFT JOIN vs. LEFT OUTER JOIN

    I've been googling for 2 hours trying to find if there is a difference between LEFT JOIN and LEFT OUTER JOIN, and of course I didn't find anything. Is there a difference? Is the word 'outer' optional, since a LEFT JOIN is an OUTER JOIN by default? If this is the case, I don't understand the usage...

    OracleATE190 pointsBadges:
  • How to show Oracle Forms at run time

    How do I show Oracle Forms at run time full screen?

    Barun15 pointsBadges:
  • Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • I am getting ORA-01422: Exact fetch returns more than requested number of rows

    Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after...

    Inprise610 pointsBadges:
  • Bulk Collect vs Cursor in Oracle

    Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table and...

    Nikhildhar35 pointsBadges:
  • Develop Oracle application by 4GL

    I am a good developer in 4gl under Informix under platform UNIX. I want to transfer to Oracle 10g under Windows 2003 Server. Would you please give me tools to write my own 4gl program in using Oracle database under Windows.

    Hamdyzawam5 pointsBadges:
  • $$PLSQL_UNIT

    Dear All, I know that using the $$PLSQL_UNIT, I can get the current procedure executing. but there is a problem when i use it to get the procedure name inside the package. it only returns the Package name not the procedure name. How can I get the PACKAGE.PROCEDUE_NAME? Please help. Ahmad Saeed...

    AhmadSaeed5 pointsBadges:
  • Searching using Oracle Forms 6i

    Hello i am using forms 6i.I have a form where I am working on some DMLs. When I enter data in text items and press save button, all the records inserted successfully. On save button there is commit_form on When_Button_Pressed trigger. The problem is when I open the same form, search for a specific...

    Rakh80 pointsBadges:
  • How to develop a executable for develper 6i

    How to develop a executable for Oracle Forms 6i & Report 6i

    Laha19825 pointsBadges:
  • Oracle directory form 6i

    HOW I CAN USE FORM 6I FOR STORE AND Retriev  A FILE IN DATABASE BY  ORACLE DIRECTORY ?

    KERMANI35 pointsBadges:
  • Error(31,19): PLS-00103: Encountered the symbol “INTO” when expecting one of the following

    I got this error while compiling a select stm and it s my pckg body however package parameter hav OUT as well IN .. Error(31,19): PLS-00103: Encountered the symbol "INTO" when expecting one of the following: . ( , % from The symbol "from was inserted before "INTO" to continue. Anbody able to help...

    Inprise610 pointsBadges:
  • iSQLPlus creating packages with multiple procedures in it

    Hi, I am a bit stuck i need to create a package which has a number of different procedures in it. The procedures work on their own however whenever i try to put them into a package they then don't work and i get the error package created with complication errors, however when i type show errors...

    Cazza8855 pointsBadges:
  • Oracle vs Java programming

    Which is better Oracle or Java? I have a interest in programming. What should I learn?

    Linux - Ask the Expert270 pointsBadges:
  • ORA106500:WHEN-BUTTON-PRESSED raised unhandled exception. … i want to open ms word file when button pressed trigger

    Dear All i am using oracle 6i and oracle 9i database i want to open word file when pressed button in form but there is no error during compilation error at runtime showing below code wrote in WNBP trigger: declare AppID PLS_INTEGER; begin AppID := DDE.App_Begin('C:ProgramDataMicrosoftwindowsstart...

    9492587845 pointsBadges:
  • Display GIS maps on Oracle forms

    I want to integrate the oracle form with GIS aplications. how can i do can u please help me on this

    Hadgilkar25 pointsBadges:
  • Default Types in Oracle Parameter Screen

    I am adding my default parameters to my stage. In the default type drop down box I see Constant, Current Date, Current Time, Field, Profile, SQL Statement and Segment. I know what most of them mean but have questions on Field, Profile and Segment. I have tried searching the web for answers but came...

    Petpat12370 pointsBadges:
  • Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following

    I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following: := . ) , @ % default character The symbol "," was substituted...

    Inprise610 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following