matpj

Clarity Date picker into Stored Procedure via GEL - problems

Discussion created by matpj on Oct 12, 2010
Latest reply on Oct 12, 2010 by matpj
Hi guys,me AGAIN!I am trying to pass a date value into a stored procedure using my GEL script.Now I have the fundamentals of the GEL/SP working, I thought i'd pass real parameters in.  my SP is defined as: create or replace procedure p_glpost (i_entity IN varchar2, i_transType IN varchar2,   i_startDate   DATE, TESTER IN VARCHAR2) is
--set serveroutput on size 1000000;
--DECLARE         v_overallMatchCount NUMBER DEFAULT 0;
  v_misMatch                   NUMBER DEFAULT 0;
  v_matchCount               NUMBER DEFAULT 0;
  v_matchID                     NUMBER DEFAULT 0;
  --declare run-time parameters
  v_fromDate VARCHAR2(10):= substr(to_char(i_startDate, 'dd/mm/yyyy'), 1, 10);
  v_toDate     VARCHAR2(10):='02/01/2008';     The error that is returned from Clarity AND in my DEV environment is:  Call P_GLPOST('DSTUK', 'L', '2008-01-01 00:00:00.0', 'newparams')
Error report:
SQL Error: ORA-01861: literal does not match format string
01861. 00000 -   "literal does not match format string"    Can anyone advise?i'm trying to convert it to a character so I can format it back in my SQL as to_datebut the format seems to come from the datepicker as '2008-01-01 00:00:00.0'  has anyone else faced similar problems with stored procedures/GEL script?  Thanks in advance,Matt    

Outcomes