Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Christi
  • Content: Threads
  • Order by date
  1. Christi

    inserting current date

    can anyone please tell me how to display current date on forms block. I have almost completed my forms design. However, I need to have the current display on the forms main menu screen. any ideas will be greatly appreciated. christi
  2. Christi

    exception handling cursors

    I am writing a cursor in forms. I test it and it appears to be working but after a while, I receive an oracle exception: ora-06502 - value error. how can I resolve, please?
  3. Christi

    calling a stored procedure

    I created a stored procedure called gt_names for my forms. the stored procedure has 3 in parameters and 4 out parameters. example create or replace gt_names(p_code1 in t.code1%type, p_code2 in b.id1%type, p_code3 in...
  4. Christi

    Before and After trigger - when to use

    I know this question is dumb but please forgive me. Like I said in an earlier thread, I am a newbie on forms, reports. My question when do I use before insert, update, delete and after insert, update, delete? I have some fields that need to perform certain actions after insert/update/delete but...
  5. Christi

    Form Trigger

    can someone please take a look at this trigger and explain to me why it is not working. What I am trying to do is make sure that cursor is moved to a specific field before an update is done on that table. the algorithm is like this: pre-update trigger before update on tableName next_item =...
  6. Christi

    Form Trigger

    can someone please take a look at this trigger and explain to me why it is not working. What I am trying to do is make sure that cursor is moved to a specific field before an update is done on that table. the algorithm is like this: pre-update trigger before update on tableName next_item =...
  7. Christi

    fetch error

    I created a form but found out that the first record was omitted. I opened up the layout editor and added this column name. Now after executing the form, I could not fetch the next record. Any attemp to do so would raise error: FRM-40507: ORACLE error: unable to fetch next query record. Is...
  8. Christi

    calling stored procs from reports

    can someone please tell me how to use trigger to call stored procedure in Oracle reports. for instance, i have a stored proc called get_emp_no. How can I write a trigger in Oracle Reports to call this procedure? thank you very much C.

Part and Inventory Search

Back
Top