Posted
by DAVID
on Stack Overflow
See other posts from Stack Overflow
or by DAVID
Published on 2010-04-27T01:18:13Z
Indexed on
2010/04/27
1:23 UTC
Read the original article
Hit count: 276
How do you write a procedure which shows that one field's value cannot be higher than another field value, in terms of numbers... ive never done one before
say. employee salary field cant be higher than his manager salary
© Stack Overflow or respective owner
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
