<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi everybody<br>
<br>
I try to call store procedure which return a ref_cursor : <br>
<br>
my store procedure :<br>
<br>
<tt>TYPE g_refcursor IS REF CURSOR;<br>
<br>
Procedure Extraire_Message_Reservation (P_Tmcid In
Tmp_Message_Client.Tmcid%Type, <br>
P_Resnum In
Rsreservation.Resnum%Type, <br>
P_Typedoc In Character,
<br>
P_Call In Character,
<br>
P_Langue In Character,<br>
rs_Message OUT
g_refcursor);<br>
</tt><br>
I use this procedure in my java program and all it ok, now I must
call in my powerhouse program (QTP).<br>
<br>
<br>
My QTP <br>
<br>
<tt>REQUEST RECUPERER_MESSAGE_CLIENT<br>
<br>
SQL DECLARE CUR_MESSAGE_CLIENT CURSOR
FOR &<br>
CALL
PCK_MESSAGE_CLIENT.EXTRAIRE_MESSAGE_RESERVATION &<br>
(UNIQUEID OF W-RS581-RESERVATION IN
, &<br>
RESNUM OF W-RS581-RESERVATION IN
, &<br>
TYPEDOC OF W-RS581-RESERVATION IN
, &<br>
CALLMOD OF W-RS581-RESERVATION IN
, &<br>
LANGUE OF W-RS581-RESERVATION IN
&
<br>
)
&<br>
RESULT
SET &<br>
TMCID VARCHAR(20)
, &<br>
TMCLIG INTEGER
, &<br>
RESNUM INTEGER
, &<br>
RMSNUM QUADWORD
, &<br>
MECNUM QUADWORD
, &<br>
RMSSECRANG SMALLINT
, &<br>
RMSIMPTIT CHARACTER(1)
, &<br>
RMSTITSEC VARCHAR(200)
, &<br>
MECTXTMSG VARCHAR(500)
, &</tt><br>
<tt> RNINUM QUADWORD</tt><br>
<br>
<tt>ACCESS *W-RS581-RESERVATION &<br>
LINK TO CUR_MESSAGE_CLIENT<br>
<br>
SORT ON RESNUM OF CUR_MESSAGE_CLIENT &<br>
ON RMSSECRANG OF CUR_MESSAGE_CLIENT &<br>
ON RMSNUM OF CUR_MESSAGE_CLIENT &<br>
ON MECNUM OF CUR_MESSAGE_CLIENT &<br>
ON TMCID OF CUR_MESSAGE_CLIENT &<br>
ON TMCLIG OF CUR_MESSAGE_CLIENT<br>
<br>
SUBFILE CUR_MESSAGE KEEP INCLUDE CUR_MESSAGE_CLIENT<br>
<br>
My log run :<br>
<br>
Exécution de la requête RECUPERER_MESSAGE_CLIENT en cours ...<br>
-------------------------------------------------------------------------------<br>
Erreur d'accès aux
données. <br>
Fichier: CUR_MESSAGE_CLIENT<br>
<br>
Opération effectuée: Fin du travail.<br>
-------------------------------------------------------------------------------<br>
DMS-E-GENERAL, Une erreur est survenue pendant l'opération
execute.<br>
Fichier: CUR_MESSAGE_CLIENT<br>
-------------------------------------------------------------------------------<br>
ORA-06550: line 1, column 7:<br>
<br>
PLS-00306: wrong number or types of arguments in call to
'EXTRAIRE_MESSAGE_RESERVATION'<br>
<br>
ORA-06550: line 1, column 7:<br>
<br>
PL/SQL: Statement ignored<br>
<br>
Fichier: CUR_MESSAGE_CLIENT<br>
<br>
<br>
</tt> I know my mistake, how do you identify an output parameter
when it is a REF_CURSOR ?<br>
<br>
Can you help me ?<br>
<tt><br>
<br>
Thanks lot <br>
</tt>
<div class="moz-signature">-- <br>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 10">
<meta name="Originator" content="Microsoft Word 10">
<link rel="File-List" href="Lessard_SIGN_2_fichiers/filelist.xml">
<title>Michel Lessard | Analyste en informatique </title>
<o:smarttagtype
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName">
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>margou</o:Author>
<o:LastAuthor>margou</o:LastAuthor>
<o:Revision>2</o:Revision>
<o:TotalTime>4</o:TotalTime>
<o:Created>2010-10-14T13:02:00Z</o:Created>
<o:LastSaved>2010-10-14T13:02:00Z</o:LastSaved>
<o:Pages>1</o:Pages>
<o:Words>151</o:Words>
<o:Characters>833</o:Characters>
<o:Company>Sépaq</o:Company>
<o:Lines>6</o:Lines>
<o:Paragraphs>1</o:Paragraphs>
<o:CharactersWithSpaces>983</o:CharactersWithSpaces>
<o:Version>10.6858</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:HyphenationZone>21</w:HyphenationZone>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if !mso]><object
classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object>
<style>
st1\:*{behavior:url(#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:536871559 0 0 0 415 0;}
@font-face
{font-family:"Monotype Corsiva";
panose-1:3 1 1 1 1 2 1 1 1 1;
mso-font-charset:0;
mso-generic-font-family:script;
mso-font-pitch:variable;
mso-font-signature:647 0 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"> <st1:personname> <span
style="font-family:Verdana;color:black">Michel <span
class="SpellE">Lessard</span> </span> </st1:personname>
<span
style="font-size:10.0pt;font-family:Verdana;color:blue"> </span>
<span
style="font-size:13.5pt;font-family:Verdana;color:gray">|
</span> <span
style="font-size:7.5pt;font-family:Verdana;color:gray">
Analyste en informatique </span> <span
style="font-size:10.0pt;font-family:Verdana; color:blue">
</span> <span
style="font-size:18.0pt;font-family:"Monotype
Corsiva"; color:#556929"><o:p></o:p> </span> </p>
<p class="MsoNormal"> <span
style="font-size:7.5pt;font-family:"Monotype
Corsiva"; color:gray"> </span> <span
style="font-size:18.0pt;font-family:"Monotype
Corsiva"; color:#556929"><o:p></o:p> </span> </p>
<p class="MsoNormal"><strong> <span
style="font-size:7.5pt;font-family:Verdana; color:gray">Société
des établissements de plein air du Québec (Sépaq) </span></strong>
<span style="font-size:18.0pt;font-family:"Monotype
Corsiva";color:#556929"><o:p></o:p> </span> </p>
<p class="MsoNormal"> <span
style="font-size:7.5pt;font-family:Verdana;color:gray">Direction
de l’informatique </span> <span
style="font-size:18.0pt;font-family:"Monotype
Corsiva"; color:#556929"><o:p></o:p> </span> </p>
<p class="MsoNormal"> <span
style="font-size:7.5pt;font-family:Verdana;color:gray">Place
de la Cité, tour <span class="SpellE">Cominar</span> </span>
<span style="font-size:18.0pt;font-family:"Monotype
Corsiva";color:#556929"><o:p></o:p> </span> </p>
<p class="MsoNormal"> <span
style="font-size:7.5pt;font-family:Verdana;color:gray">2640,
boulevard Laurier, bureau 1300 </span> <span
style="font-size:18.0pt;font-family:"Monotype
Corsiva";color:#556929"><o:p></o:p></span> </p>
<p class="MsoNormal"> <span
style="font-size:7.5pt;font-family:Verdana;color:gray">Québec (Québec)
G1V 5C2 </span> <span
style="font-size:18.0pt;font-family:"Monotype
Corsiva";color:#556929"><o:p></o:p></span> </p>
<p class="MsoNormal"> <span
style="font-size:7.5pt;font-family:Verdana;color:gray">Téléphone
: 418 380-5875, poste 2334 </span> <span
style="font-size:18.0pt;font-family:"Monotype
Corsiva";color:#556929"><o:p></o:p></span> </p>
<p class="MsoNormal"> <span
style="font-size:7.5pt;font-family:Verdana;color:gray">Télécopieur
: 418 528-1467</span><span
style="font-size:18.0pt;font-family:"Monotype
Corsiva"; color:#556929"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:7.5pt;font-family:Verdana;color:gray">Courriel
: <a href="mailto:lessard.michel@sepaq.com">lessard.michel@sepaq.com</a>
</span><span
style="font-size:18.0pt;font-family:"Monotype
Corsiva";color:#556929"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:7.5pt;font-family:"Monotype
Corsiva"; color:gray"> </span><span
style="font-size:18.0pt;font-family:"Monotype
Corsiva"; color:#556929"><o:p></o:p></span></p>
<p class="MsoNormal"><strong><span
style="font-size:7.5pt;font-family:Verdana; color:green">Est-ce
nécessaire d'imprimer ce courriel ?</span></strong><span
style="font-size:18.0pt;font-family:"Monotype
Corsiva";color:#556929"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:7.5pt;font-family:"Monotype
Corsiva"; color:gray"> </span><span
style="font-size:18.0pt;font-family:"Monotype
Corsiva"; color:#556929"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:7.5pt;font-family:Verdana;color:gray">AVIS
DE CONFIDENTIALITÉ : Le présent courrier et les fichiers
qui l'accompagnent peuvent contenir des informations
confidentielles ou privilégiées à l'attention exclusive
des destinataires désignés. Si vous n'êtes pas l'un de ces
destinataires, son employé ou son mandataire dûment
autorisé, soyez avisé que toute diffusion ou reproduction
de ce courrier, de ses fichiers joints ou de leur contenu,
est interdite. Si vous avez reçu cette transmission par
erreur, veuillez communiquer immédiatement avec
l'expéditeur. Nous vous remercions de votre collaboration.</span><span
style="font-size:18.0pt;font-family:"Monotype
Corsiva"; color:#556929"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</o:smarttagtype></div>
</body>
</html>