You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Dheeraj Dhiman (JIRA)" <de...@db.apache.org> on 2006/04/13 08:14:59 UTC
[jira] Created: (DERBY-1211) I have some problem at time of using
procedure in Apache derby !
I have some problem at time of using procedure in Apache derby !
----------------------------------------------------------------
Key: DERBY-1211
URL: http://issues.apache.org/jira/browse/DERBY-1211
Project: Derby
Type: Bug
Versions: 10.0.2.0
Environment: Embedded Driver
Reporter: Dheeraj Dhiman
Priority: Critical
Hello !!
I want to switch from sql server to apache Derby for my project .
I wanna run a procedure like this in apache derby .
create procedure testProcedure( @personid Integer )
as
select fullName , fatherName, age, income, grosssalary from persons where personid = @personid ;
But it is not working .
How could i write this procedure in apache derby !!
& one thing more I want to return multiple values from a procedure or may be function !!
Can procedure return a result set from a procedure or function !! If yes then pls send proper example !!
If you have no solution of this problem then pls given proper & correct address where
can I get proper solution of this problem !!
I m also try to send this problem on address derby-user@db.apache.org
&& derby-user-subscribe@db.apache.org
But no response come from these addresses !!
Thanks & Regards !!
Dheeraj Dhiman !!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Closed: (DERBY-1211) I have some problem at time of using
procedure in Apache derby !
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1211?page=all ]
Kathey Marsden closed DERBY-1211:
---------------------------------
Resolution: Invalid
Closing this as invalid as it is not a bug.
Also the Priority of Critical is for Crashes, loss of data, mem leaks, regressions etc.
For user questions, typical protocol is:
1) Search the search box at http://db.apache.org/derby/. "create procedure" might be a good search here.
2) If no answer is found, post a question to derby-user mailing list
3) Wait a reasonable amount of time for an answer before reposting your question.
> I have some problem at time of using procedure in Apache derby !
> ----------------------------------------------------------------
>
> Key: DERBY-1211
> URL: http://issues.apache.org/jira/browse/DERBY-1211
> Project: Derby
> Type: Bug
> Versions: 10.0.2.0
> Environment: Embedded Driver
> Reporter: Dheeraj Dhiman
> Priority: Critical
>
> Hello !!
> I want to switch from sql server to apache Derby for my project .
> I wanna run a procedure like this in apache derby .
> create procedure testProcedure( @personid Integer )
> as
> select fullName , fatherName, age, income, grosssalary from persons where personid = @personid ;
> But it is not working .
> How could i write this procedure in apache derby !!
> & one thing more I want to return multiple values from a procedure or may be function !!
> Can procedure return a result set from a procedure or function !! If yes then pls send proper example !!
> If you have no solution of this problem then pls given proper & correct address where
> can I get proper solution of this problem !!
> I m also try to send this problem on address derby-user@db.apache.org
> && derby-user-subscribe@db.apache.org
> But no response come from these addresses !!
> Thanks & Regards !!
> Dheeraj Dhiman !!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira