On Sun, Jan 23, 2005 at 02:59:36PM -0800, Ryan Miranda wrote: > I am trying to run the proc below but get an error : invalid input > syntax for type bigint: "2004-10-26" Can anyone suggest what I am > doing wrong here?
Apparently you're trying to use a date where a bigint is expected. One possibility might be here: > SELECT ix_workflow_task."DATE_COMPLETED", > ix_workflow_task."WORKFLOW_ACTIVITY_XPDL_ID", ix_workflow_task."TYPE" > INTO workflow_t from ix_workflow_task You declared workflow_t to be ix_workflow_task%ROWTYPE but you're only selecting certain fields into it. Is the first field in ix_workflow_task perchance a bigint? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
