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/12 15:16:22 UTC

[jira] Created: (DERBY-1206) Pls Give me Suggestion about Procedure Problem !!

Pls Give me Suggestion about Procedure Problem !!
-------------------------------------------------

         Key: DERBY-1206
         URL: http://issues.apache.org/jira/browse/DERBY-1206
     Project: Derby
        Type: Bug

  Components: SQL  
    Versions: 10.0.2.0    
 Environment: Embedded Driver 
    Reporter: Dheeraj Dhiman
    Priority: Critical


I m using apache derby for my Project !!
In this project we want to make a function 
which accecpt three long argument & i want to return Object[] ( Object Array ) !!
Can this is possible in apache derby if yes then pls give example !!

My Case is :::

create function myprocedure( id1 bigint , id2 bigint , id3 bigint ) returns Object[] parameter style java reads sql data language java external name 'myclass.myProcedureMethod' ;

class myclass{
public static Object[] myProcedureMethod(long id1 , long id2 , long id3){

return new Object[32];
}
}

Thanks !!



-- 
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-1206) Pls Give me Suggestion about Procedure Problem !!

Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1206?page=all ]
     
Jean T. Anderson closed DERBY-1206:
-----------------------------------

    Resolution: Invalid

This is an excellent question, but the right place to ask it is on the derby-user@db.apache.org mail list, so please post it there. To subscribe, send email to derby-user-subscribe@db.apache.org. More information about Derby mail lists is at http://db.apache.org/derby/derby_mail.html .

> Pls Give me Suggestion about Procedure Problem !!
> -------------------------------------------------
>
>          Key: DERBY-1206
>          URL: http://issues.apache.org/jira/browse/DERBY-1206
>      Project: Derby
>         Type: Bug

>   Components: SQL
>     Versions: 10.0.2.0
>  Environment: Embedded Driver 
>     Reporter: Dheeraj Dhiman
>     Priority: Critical

>
> I m using apache derby for my Project !!
> In this project we want to make a function 
> which accecpt three long argument & i want to return Object[] ( Object Array ) !!
> Can this is possible in apache derby if yes then pls give example !!
> My Case is :::
> create function myprocedure( id1 bigint , id2 bigint , id3 bigint ) returns Object[] parameter style java reads sql data language java external name 'myclass.myProcedureMethod' ;
> class myclass{
> public static Object[] myProcedureMethod(long id1 , long id2 , long id3){
> return new Object[32];
> }
> }
> Thanks !!

-- 
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