Search results for query: *

Thanks lewisp. Carla

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.

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...

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...

Thank you.

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...

Thanks Sreenivas, But what about that kind of message which has variable in it. This variable will be replaced by the column or other information? Regards, Carla

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...