Re: Printing from PL/SQL

From: Allan Davis Sahadeo <asahadeo_at_neal-and-massy.com>
Date: Fri, 10 Nov 2000 17:18:10 -0400
Message-Id: <10676.121801@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_04D5_01C04B3A.336DE3C0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Printing from PL/SQLMark

You should look under DBMS_PIPE utility to do something like this. = There is a document on the metalink outlining how to go about using this = do what I think you are suggesting.
Your search should be "Dynamic SQL and System Commands Using DBMS_PIPE". = I would have sent it to you but am afraid of breaking any international = copyright laws.
Sincerely,
Allan.

Original Message -----=20 From: Myszkowski.Mark=20 To: Multiple recipients of list ORACLE-L=20 Sent: Friday, November 10, 2000 3:01 PM Subject: Printing from PL/SQL

Hi Everyone=20
Does anyone have any suggestions on how to print from PL/SQL in Unix? = This would be used in an update/insert trigger. The trigger would look = at the data modified and send a report to one of about 40 possible = printers. This would be for implementing a trouble ticket printing = application.

(If such a thing is not possible then how else can this be achieved - = Pro*C perhaps?)=20
Thanks for any suggestions - I appreciate it.=20 Mark Myszkowski=20

------=_NextPart_000_04D5_01C04B3A.336DE3C0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Printing from PL/SQL</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#a0a0a8>
<DIV><FONT face=3DArial size=3D2>Mark</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>    You should look =
under DBMS_PIPE=20
utility to do something like this. There is a document on the metalink = outlining=20
how to go about using this do what I think you are = suggesting.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Your search should be "Dynamic SQL and =
System=20
Commands Using DBMS_PIPE". I would have sent it to you but am afraid of = breaking=20
any international copyright laws.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Sincerely,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Allan.</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:Mark.Myszkowski_at_wepco.com"=20   title=3DMark.Myszkowski_at_wepco.com>Myszkowski.Mark</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, November 10, 2000 = 3:01=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Printing from = PL/SQL</DIV>
  <DIV><BR></DIV>
  <P><FONT face=3DArial size=3D2>Hi Everyone</FONT> <BR><FONT = face=3DArial size=3D2>Does=20
  anyone have any suggestions on how to print from PL/SQL in Unix?  = This=20
  would be used in an update/insert trigger.  The trigger would = look at the=20
  data modified and send a report to one of about 40 possible = printers. =20
  This would be for implementing a trouble ticket printing=20   application.</FONT></P>
  <P><FONT face=3DArial size=3D2>(If such a thing is not possible then = how else can=20
  this be achieved - Pro*C perhaps?)</FONT> <BR><FONT face=3DArial = size=3D2>Thanks=20
  for any suggestions - I appreciate it.</FONT> <BR><FONT face=3DArial = size=3D2>Mark=20
  Myszkowski</FONT> </P></BLOCKQUOTE></BODY></HTML> Received on Fri Nov 10 2000 - 15:18:10 CST