Please Help: ORA-01847 for valid date

Ken Denny · *nix forums beginner Joined: 08 Apr 2005 Posts: 16

wdewebserver wrote:

casey.kirkpatrick@gmail.c · *nix forums beginner Joined: 08 Jun 2005 Posts: 20

It's called debugging.

Rather than OPEN your V_STRING (and report errors to a public
discussion board), why not print V_STRING, and see what your SELECT
actually looks like.

DA Morgan · *nix forums Guru Joined: 06 Mar 2005 Posts: 1042

wdewebserver wrote:

wdewebserver · *nix forums beginner Joined: 22 Feb 2005 Posts: 5

Hi

I have written the following stored procedure hoping to extract data from a
table. When I call the stored proc using a date like 10-11-2004, I get an
error ORA-01847: day of month must be between 1 and last day of month.

Procedure "dynamic"
(
vTABLE_NAME IN CHAR,
vCREATED_DATE IN CHAR,
vREF_CURSOR OUT GLOA.RCT
)
AS
V_STRING VARCHAR2(1000);
BEGIN
V_STRING := 'SELECT XRED, YFER FROM '||vTABLE_NAME||' '||
'WHERE CREATED_DATE = TO_DATE('||vCREATED_DATE||',''DD-MM-YYYY'')'

OPEN vREF_CURSOR FOR V_STRING;
END dynamic;

Google