Posts by Julie • 21 points

• 0

  votes

  1

  answer

  84

  views

  Q: Create user using a Function

  someone could help me, she keeps giving error when saved '-' Error(19,5): PLS-00103: Encountered the Symbol "CREATE" when expecting one of the following: ( start case declare quit for goto if loop…

  sql database oracle function oracle11c

  asked 8 years, 1 month ago Julie 21

• 1

  votes

  1

  answer

  1899

  views

  A: Call Procedure inside another

  create or replace PROCEDURE PP_ENVIAR_EMAIL is CURSOR anv IS SELECT distinct mat_servidor, nom, dt_nasc, e_mail FROM srh2.servidor WHERE MONTHNAME(DT_NASC) = MONTHNAME(SYSDATE); SELECT distinct…

  sql database procedure stored-procedures oracle10g

  answered 8 years, 2 months ago Julie 21

• -1

  votes

  1

  answer

  1899

  views

  Q: Call Procedure inside another

  I need to create a precedent enviar_email_servidores call in another pr_envia_email. The term to be called (pr_envia_email) has the function of sending email, and I need the message sent to this…

  sql database procedure stored-procedures oracle10g

  asked 8 years, 2 months ago Julie 21