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 "Prakash (JIRA)" <ji...@apache.org> on 2007/07/12 14:05:05 UTC
[jira] Created: (DERBY-2930) create and call a procedure in derby
db
create and call a procedure in derby db
---------------------------------------
Key: DERBY-2930
URL: https://issues.apache.org/jira/browse/DERBY-2930
Project: Derby
Issue Type: Wish
Reporter: Prakash
Priority: Critical
I would like to know hw to create a procedure in derby db and how to call that procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2930) create and call a procedure in derby
db
Posted by "V.Narayanan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512082 ]
V.Narayanan commented on DERBY-2930:
------------------------------------
Derby has support for java stored procedures. You can find more
information on this here
http://wiki.apache.org/db-derby/DerbySQLroutines. Also the page has some
sample code that shows how to go about doing the same.
I however am not sure this should have been a jira issue.
> create and call a procedure in derby db
> ---------------------------------------
>
> Key: DERBY-2930
> URL: https://issues.apache.org/jira/browse/DERBY-2930
> Project: Derby
> Issue Type: Wish
> Reporter: Prakash
> Priority: Critical
>
> I would like to know hw to create a procedure in derby db and how to call that procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-2930) create and call a procedure in derby db
Posted by "Kristian Waagan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristian Waagan closed DERBY-2930.
----------------------------------
> create and call a procedure in derby db
> ---------------------------------------
>
> Key: DERBY-2930
> URL: https://issues.apache.org/jira/browse/DERBY-2930
> Project: Derby
> Issue Type: Wish
> Reporter: Prakash
> Priority: Critical
>
> I would like to know hw to create a procedure in derby db and how to call that procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2930) create and call a procedure in derby
db
Posted by "Prakash (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512358 ]
Prakash commented on DERBY-2930:
--------------------------------
Dear Narayanan
To introduce my self i am Prakash.
Where i work we use derby as db for our product.
To execute the commends and view the data base we have derby.jar [10.2.2.0]
The diffucult i faced :
on refering "reference_derby_10_3_manuals.pdf" and "derbydev.pdf" i came to know hw to write a "procedure" but
when i tried to call the same with the "call" command it did generate error message.
Hope you could assist me in this issue.
Thank you for allocating few of your valuable time in reading my mail.
Regds - K.Prakash
> create and call a procedure in derby db
> ---------------------------------------
>
> Key: DERBY-2930
> URL: https://issues.apache.org/jira/browse/DERBY-2930
> Project: Derby
> Issue Type: Wish
> Reporter: Prakash
> Priority: Critical
>
> I would like to know hw to create a procedure in derby db and how to call that procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2930) create and call a procedure in derby
db
Posted by "V.Narayanan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512379 ]
V.Narayanan commented on DERBY-2930:
------------------------------------
Hi prakash,
I'd be glad to help you out here. But as Bryan has already mentioned
we think it would be really nice of you if you could post your question
to derby-user@db.apache.org.
The following nabble thread will reveal the number of questions that
have been
raised related to stored procedures in derby and the answers got.
http://www.nabble.com/forum/Search.jtp?forum=93&local=y&query=stored+procedures
I request you to kindly post the same query in derby-user@db.apache.org
Narayanan
> create and call a procedure in derby db
> ---------------------------------------
>
> Key: DERBY-2930
> URL: https://issues.apache.org/jira/browse/DERBY-2930
> Project: Derby
> Issue Type: Wish
> Reporter: Prakash
> Priority: Critical
>
> I would like to know hw to create a procedure in derby db and how to call that procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-2930) create and call a procedure in derby
db
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton resolved DERBY-2930.
------------------------------------
Resolution: Invalid
Yes, please send your questions to derby-users@db.apache.org rather than creating entries in JIRA.
> create and call a procedure in derby db
> ---------------------------------------
>
> Key: DERBY-2930
> URL: https://issues.apache.org/jira/browse/DERBY-2930
> Project: Derby
> Issue Type: Wish
> Reporter: Prakash
> Priority: Critical
>
> I would like to know hw to create a procedure in derby db and how to call that procedure.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.