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 TouchToneTommy 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: *

  1. carlavieira

    Verifing the data type

    Hi, I'd like to know how can I verify if the variable contains only the data type that I'm expecting for. In SQLSERVER we have the IS_NUMERIC, IS_CHAR... functions. Is there something similar in ORACLE? How can I use it? Thanks.
  2. carlavieira

    Message error

    Hi, I'm working with SQL SERVER 2000 and some messages have variable in their. How can I have this variable replaced by the column or other information? Eg.: error 2627 - Violation of %ls constraint '%.*ls'. Cannot insert duplicate key in object '%.*ls'. P.S.: I'm doing it in procedure...
  3. carlavieira

    Message Error

    Hi, Some messages have variable in their. How can I have this variable replaced by the column or other information? Eg.: error 2627 - Violation of %ls constraint '%.*ls'. Cannot insert duplicate key in object '%.*ls'. P.S.: I'm doing it in procedure which will be run in the query analyzer...
  4. carlavieira

    @@ROWCOUNT

    Hi, I have a SP and I put after close cursor this statement: print str(@@ROWCOUNT) + 'registros incluídos.' To know how much records are inserted. But it didn't work. 177 records are inserted and the return was: 0registros incluídos. Any idea about what can I do to have the number of...
  5. carlavieira

    Getting the error message

    I have a procedure that will be executed by job or query analyzer. Within I have an insert: insert tab1 (cp1,cp2) values (@cp1,@cp2) IF (@@error <> 0) begin goto grava_erro end . . . grava_erro: select @msg_erro = description from sysmessage where error = @@error...

Part and Inventory Search

Back
Top