Message function

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Wed, 01 Aug 2007 4:32 pm

Ola galera!...

Had a function that I put on procedure and showed the message I wanted to check Whither served this giving error in procedure that I created.

Anyone know the name of this function? db something ...rsrsr
rickab7
Location: campo grande

stephany henrique de almeida batista

Poston Wed, 01 Aug 2007 4:39 pm

Would the Dbms_output.put_line.PUT_LINE?

Example:
Code: Select all
BEGIN
  DBMS_OUTPUT.PUT_LINE(' LINHA X: ' || TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
END;
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Wed, 01 Aug 2007 4:46 pm

Remembering that to work the DBMS_OUPUT, have to before typing like this:
Code: Select all
SET SERVEROUTPUT ON
:-
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Wed, 01 Aug 2007 4:53 pm

Guys have once again thanks to all of you
rickab7
Location: campo grande

stephany henrique de almeida batista



Return to SQL

Who is online

Users browsing this forum: Google Adsense [Bot], Majestic-12 [Bot] and 7 guests