hoo! Messenger Version 8. Get
it NOW
-- Forwarded message --
From: puneet arya <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Mon, 20 Nov 2006 08:08:21 + (GMT)
Subject: how to use function
Hi,
i m trying to use a select query like
select count(*) as personcount from
Hi, i want to insert a varchar value which is generated by a function(returning varchar). i m inserting a value like insert into emp values(fn_idgenerator,name) but at oracle level if i run this it is running fine(mean inserting values) but at oracle level how to map it and run it can any
To: user-java@ibatis.apache.org
cc: (bcc: Viktor X. Kopit/CIO/HHQ/HUD)
Subject: Re: how to use function in resultMap
hi,
ya i have defined my stored procedure as
CREATE OR REPLACE PROCEDURE SP_EMPLOYEE(name IN VARCHAR2, employee_cur
006 09:35
Please respond to user-java
To: user-java@ibatis.apache.org
cc:
Subject: Re: how to use function in resultMap
hi,
thank you very much it is working with alias .. :-)
Regards,
Puneet Arya
[EMAIL PROTECTED] wrote:
i send you an e
7 51[EMAIL PROTECTED]puneet arya <[EMAIL PROTECTED]> 28/06/2006
09:16 Please respond to user-java To: user-java@ibatis.apache.org cc: Subject: Re: how to use function in resultMaphi, thx Puneet Arya[EMAIL PROTECTED] wrote: i have
-java
To: user-java@ibatis.apache.org
cc:
Subject: Re: how to use function in resultMap
hi,
thx
Puneet Arya
[EMAIL PROTECTED] wrote:
i have made an oraclecursor with alias in the columns and i have no problem... i don´t understand
if
r-java To: user-java@ibatis.apache.org cc:
Subject: Re: how to use function in resultMaphi, Yes You are right ki should not have name in the resultMap but alias we cant put like that . not only in this case(where i m using sum function) but in the
he.org
cc:
Subject: Re: how to use function in resultMap
hi,
Yes You are right ki should not have name in the resultMap but alias we cant put like that . not only in this case(where i m using sum function) but in the normal case when we are using resultMap alias ca
-java To: user-java@ibatis.apache.org cc: Subject: how to use function in resultMapHi, I am trying to use sum function (Pl/Sql) in my stored procedure as select sum(salary) from employeeInfo; But while defining a result Map i m writing as
o user-java
To: user-java@ibatis.apache.org
cc:
Subject: how to use function in resultMap
Hi,
I am trying to use sum function (Pl/Sql) in my stored procedure as
select sum(salary) from employeeInfo;
But while defining a result
user-java@ibatis.apache.org cc: Subject: Re: how to use function in resultMaphi, ya i have defined my stored procedure as CREATE OR REPLACE PROCEDURE SP_EMPLOYEE(name IN VARCHAR2, employee_cursor OUT vattypes.vat_cursor) AS BEGIN open employee
<[EMAIL PROTECTED]>
28/06/2006 08:30
Please respond to user-java
To: user-java@ibatis.apache.org
cc:
Subject: Re: how to use function in resultMap
hi,
ya i have defined my stored procedure as
CREATE OR REPLACE PRO
hi, ya i have defined my stored procedure as CREATE OR REPLACE PROCEDURE SP_EMPLOYEE(name IN VARCHAR2, employee_cursor OUT vattypes.vat_cursor) AS BEGIN open employee_cursor for select sum(salary) from employeeInfo where name = name; END; If I remove the sum functi
can you tell me how you defined the oracle cursor in the pl-sql fuction..??
Esperanza Echeverría de Miguel
Steria España http://www.steria.es
C/Menéndez y Pelayo,3 bis 46010 Valencia
Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
[EMAIL PROTECTED]
96 393 87 51[EMAIL PROTECTED]puneet arya <[EMAIL PROTECTED]> 28/06/2006 07:57 Please respond to user-java To: user-java@ibatis.apache.org cc: Subject: how to use function in resultMapHi, I am trying to use sum functi
but the problem is about the property salary, take a look for the name you put it in the pl-sql...
Esperanza Echeverría de Miguel
Steria España http://www.steria.es
C/Menéndez y Pelayo,3 bis 46010 Valencia
Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
[EMAIL PROTECTED]
6/2006 07:57
Please respond to user-java
To: user-java@ibatis.apache.org
cc:
Subject: how to use function in resultMap
Hi,
I am trying to use sum function (Pl/Sql) in my stored procedure as
select sum(salary) from employeeInfo;
But
Hi, I am trying to use sum function (Pl/Sql) in my stored procedure as select sum(salary) from employeeInfo; But while defining a result Map i m writing as
Hi, I am trying to use sum function (Pl/Sql) in my stored procedure as select sum(salary) from employeeInfo; But while defining a result Map i m writing as
19 matches
Mail list logo
