-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Eighteen months ago I showed Tutor and UPK Productive Day One overview to a CIO friend of mine. He works in a manufacturing business which had been recently purchased by a global conglomerate. He had a major implementation coming up, but said that the corporate team would be coming in to handle the…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Here's the problem (sorry for the bad english):
i'm working with JDeveloper and Oracle10g, and i have a Java Stored Procedure that is calling another JSP like the code:
int sd = 0;
try {
CallableStatement clstAddRel = conn.prepareCall(" {call FC_RJS_INCLUIR_RELACAO_PRODCAT(?,?)} ");
clstAddRel…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
delimiter //
CREATE DEFINER=root@localhost PROCEDUREgetData(IN templateName VARCHAR(45),IN templateVersion VARCHAR(45),IN userId VARCHAR(45))
BEGIN
set @version = CONCAT("SELECT saveOEMsData_answersVersion FROMsaveOEMsData WHERE saveOEMsData_templateName = '",templateName,"' ANDsaveOEMsData_templateVersion…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
How to call stored procedure from another stored procedure and return the result as first one's column?
ALTER PROCEDURE [dbo].[GetItems]
AS
SET NOCOUNT ON
SELECT ID, AddedDate, Title,Description,
Result of Stored Procedure "CountAll" call with parameter ID as Total
FROM dbo.Table1
And…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a MYSQL stored procedure SP1() that returns a result set.
I want to call SP1() inside of SP2() and loop through the result set of SP1() to do some additional work.
I don't want to include my logic from SP1() because it would make SP2() too complicated.
Any suggestions?
Thanks.
>>> More
