Welcome, Guest
Please Login or Register.    Lost Password?

how to use test to view stored procedure's result?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: how to use test to view stored procedure's result?
#182
how to use test to view stored procedure's result? 1 Year, 5 Months ago Karma: 0  
Hi,
I am a beginner,
I defined a simple stored procedure which contains two IN DateTime parameters shown in the following
CREATE DEFINER=`root`@`localhost` PROCEDURE `TimeDiff`(IN s_date DATETIME, IN e_date DATETIME)
BEGIN
DECLARE StartDate,EndDate DATETIME;
SET @StartDate= s_date;
SET @EndDate=e_date;
SET @UnitDate =(DATEDIFF(@EndDate,@StartDate));
select @UnitDate;
END
It works fine when Java calls this stored procedure or clicking ‘Run’ stored procedure in navicat tool. However,when I use DreamCoder , it’s strange to see datatype is unknown in the clip, and when I input date time in value, for an example, 2010-08-22, it doesn’t work even I try to change datatype to Date or TimeStamp.
Can anyone tell me how to use DreamCoder test tool to get the result ?

Any suggestions or hints will be appreciated.
Many thanks
jessary (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
get the latest posts directly to your desktop

Why DreamCoder

DreamCoder is downloaded over 1 millions time and has accumulated over 10.000 happy customers from over 100 countries in the last 8 years.
Now we are the best database tools availabe 100% free in the world for Oracle , MySQL and PostgreSQL.

Community

 SQLDeveloper support forums
Join our Community
and help us create better products
Home