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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by NewtUK

  1. NewtUK

    Stored Procedure not working from Forms 6

    Not at this point, no. However, testing the system this morning has provided the correct results - the password encrypted. I guess I can only put this down to user incompetence. Thanks for your help guys, and apologies for wasting your time. :-( Rich
  2. NewtUK

    Stored Procedure not working from Forms 6

    The encryptPassword procedure places the encrypted value of the plaintext password into a table. This functions fine when called from SQL*Plus, but called from Forms places the original plain text value into the table. The encryptPassword procedure is defined as follows: PROCEDURE...
  3. NewtUK

    Stored Procedure not working from Forms 6

    Hi, I wonder if anyone can help with this. We have a stored procedure called InsertStaff that inserts records into several tables and calls another procedure called encryptPassword that has been defined in the same package. When calling the InsertStaff procedure from SQL*Plus or via a Java...
  4. NewtUK

    ORA-00767 : Any ideas?

    Our Oracle developer has looked at the code and discovered that the trigger(s) in question did not like the use of a char type variable, as opposed to a varchar2 type variable. Changing this type appears to have resolved the issue. Rich
  5. NewtUK

    ORA-00767 : Any ideas?

    I'll take a look and have a chat with our dedicated Oracle developer. Cheers for the advice and happy new year :-) Rich
  6. NewtUK

    ORA-00767 : Any ideas?

    It looks authentic as it is displayed as an unhandled exception on a WHEN-VALIDATE-ITEM trigger. Unfortunately, there is no easy way of knowing exactly which instance of this trigger it refers to (the situation is such that a great deal of information is being automatically populated in the...
  7. NewtUK

    ORA-00767 : Any ideas?

    Yes, that is definitely the code I get and I can reproduce it quite easily, but it does only happen under certain circumstances (the circumstances being certain combinations of information required by our system). Regards Richard
  8. NewtUK

    ORA-00767 : Any ideas?

    We are in the process of converting Forms 4.5 modules to Forms 6 and testing them against a 9i database. For the most part, this is going okay. However, in one instance we are getting the error ORA-00767, but there is no description in the error text, the server messages and codes manual, or...
  9. NewtUK

    how to clear documnet.writeln before writing

    You can use onBlur() in the <body> tag too. <body onBlur='this.focus'> Just tested this in IE5.5 to be sure and works fine - should work in NS6, too.
  10. NewtUK

    how to clear documnet.writeln before writing

    You need to make sure that you close the document when you have finished writing: document.close(); This will prevent you from writing any additional information to the page. Rich
  11. NewtUK

    Form.submit() okay IE5.5 but not IE5.0

    Cheers, mate. I realised I could just use href='#' since the function carries out the submission and it doesn't matter if the page jumps to the top since that is where the link is anyway.
  12. NewtUK

    Form.submit() okay IE5.5 but not IE5.0

    Please ignore that last one - my brain's not working properly lately!!
  13. NewtUK

    Form.submit() okay IE5.5 but not IE5.0

    Okay, I got the stuff to work based on all the suggestions, however, some changes have had to be made which means that I cannot call this function from the href attribute - I am now having to pass 'this' back to the function which means that the window gets passed back and not the anchor object...
  14. NewtUK

    Form.submit() okay IE5.5 but not IE5.0

    Cheers guys. Worked a treat.
  15. NewtUK

    Form.submit() okay IE5.5 but not IE5.0

    Mmmm, so it is!! Must admit, I've never used Javascript in the href attribute before - never realised it could be done (I've only been picking it up as I go along so have big gaps in my knowledge). I'll do this when I get back to work tomorrow. Cheers for your help
See more

Part and Inventory Search

Back
Top