Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: procedure error

RE: procedure error

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 16 Jan 2002 14:53:14 -0800
Message-ID: <F001.003F1FD9.20020116142527@fatcity.com> 







DROP 



and CREATE are DDL functions ... you have to use DBMS_SQL package or Native 
Dynamic SQL (execute immediate) statement to achieve this.
<FONT face=Arial color=#0000ff 


size=2> 


<FONT face=Arial color=#0000ff 


size=2>Raj


<FONT face="Courier New" 

size=2>______________________________________________________


Rajendra 


Jamadagni      


        MIS, ESPN Inc.


Rajendra dot Jamadagni at ESPN dot 


com


Any opinion expressed here is 


personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but 


having an opinion is an <FONT 


face="Courier New" size=2>art!



  <FONT face=Tahoma 


  size=2>-----Original Message-----From: Lance Prais 
  [mailto:lprais_at_ts.checkpoint.com]Sent: Wednesday, January 16, 2002 
  4:36 PMTo: Multiple recipients of list ORACLE-LSubject: 
  procedure error
  
    
    


    <FONT face=Arial color=#0000ff 



    size=2>Why in toad when I try to create a stored proc where I drop and 
    create a table I get the following error:  


    <FONT face=Arial color=#0000ff 



    size=2> 


    <FONT face=Arial color=#0000ff 



    size=2>PLS-00103: Encountered the symbol "DROP" when expecting one of the 
    following:


    <FONT face=Arial color=#0000ff 



    size=2>   begin function package pragma procedure subtype type 
    use   <an identifier> <a double-quoted 
    delimited-identifier> cur


     


     


    <FONT face=Arial color=#0000ff 



    size=2>Here is my code:


    <FONT face=Arial color=#0000ff 



    size=2> 


    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">CREATE<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">OR<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">REPLACE<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">PROCEDURE<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: olive; FONT-FAMILY: Courier">Primus_Report<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 



    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">AS<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">


    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">Drop<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">Table<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: olive; FONT-FAMILY: Courier">PRIMUS_TEMP_DUMP<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">;<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">CREATE<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">TABLE<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: olive; FONT-FAMILY: Courier">PRIMUS_TEMP_DUMP<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  SOLUTION_ID<SPAN 
    style="mso-spacerun: yes">              




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">85<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">)<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">NOT<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">NULL,<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  TITLE<SPAN 
    style="mso-spacerun: yes">                    




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">3498<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  OWNER<SPAN 
    style="mso-spacerun: yes">                    




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">255<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  P_TYPE<SPAN 
    style="mso-spacerun: yes">                   




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">96<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  AUTHOR<SPAN 
    style="mso-spacerun: yes">                   




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">255<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  MODIFIED_BY<SPAN 
    style="mso-spacerun: yes">              




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">255<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  ESCALATION_GROUP<SPAN 
    style="mso-spacerun: yes">         




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">255<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  TECH_RESOURCE<SPAN 
    style="mso-spacerun: yes">            




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">255<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  P_PARTITION<SPAN 
    style="mso-spacerun: yes">              




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">96<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  STATUS<SPAN 
    style="mso-spacerun: yes">                   




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">96<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  HyperLinks<SPAN 
    style="mso-spacerun: yes">     <SPAN 
    style="mso-tab-count: 2">            


       <SPAN 

    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">96<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  Style_reviewer<SPAN 
    style="mso-tab-count: 2">          




       <SPAN 

    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">96<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  DATE_CREATED<SPAN 
    style="mso-spacerun: yes">             




    <SPAN 



    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">DATE,<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">


    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  DATE_MODIFIED<SPAN 
    style="mso-spacerun: yes">            




    <SPAN 



    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">DATE,<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">


    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  ALERT<SPAN 
    style="mso-spacerun: yes">                    




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">96<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  URGENCY<SPAN 
    style="mso-spacerun: yes">                  




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">96<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  NO_PAGEVIEWS_LAST_MONTH<SPAN 
    style="mso-spacerun: yes">  <SPAN 
    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">255<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  NO_PAGEVIEWS_QUARTER<SPAN 
    style="mso-spacerun: yes">     <SPAN 
    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">255<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  NO_LINKS_LAST_WEEK<SPAN 
    style="mso-spacerun: yes">       




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">255<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">),<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"><SPAN 
    style="mso-spacerun: yes">  NO_LINKS_LAST_MONTH<SPAN 
    style="mso-spacerun: yes">      <SPAN 
    style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Courier">VARCHAR2<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: maroon; FONT-FAMILY: Courier">255<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">)<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">);<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">INSERT<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">INTO<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: olive; FONT-FAMILY: Courier">PRIMUS_TEMP_DUMP<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">(<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">solution_id<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">,<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">Title<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">)<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">SELECT<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> 


    pc_solution_id<SPAN 


    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">,<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> pc_title 


    <SPAN 


    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">FROM<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier"> <SPAN 
    style="FONT-SIZE: 10pt; COLOR: olive; FONT-FAMILY: Courier">pt_solution<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">;<SPAN 
    style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Courier">




    <SPAN 



    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier">end;<SPAN 
    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">


    <SPAN 



    style="FONT-SIZE: 10pt; COLOR: #0000f0; FONT-FAMILY: Courier; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">/



*********************************************************************1





This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.


*********************************************************************1


Received on Wed Jan 16 2002 - 16:53:14 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US