• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

Null date for Oracle procedure.

Hi.

I'm passing a load of variables to an Oracle 8 stored procedure, but I'm having problems with one of them.

Does anyone know if there are issues with passing a date field a null value from Delphi?  Without going into loads of detail I can't give you much more info.  Unfortunately the code is not mine to give out (even though I wrote it), so I'll just have to rely on your understanding of my explanation.

Thanks,

John.
0
Jaymol
Asked:
Jaymol
  • 4
  • 3
1 Solution
 
kretzschmarCommented:
storedProc1.ParamByName('DateParam').Clear; //will force a null-value
0
 
kretzschmarCommented:
more specific

...
if MyTDateTimeTypVar = 0 then  //or what condition you have
  storedProc1.ParamByName('DateParam').Clear
else
storedProc1.ParamByName('DateParam').AsDateTime := MyTDateTimeTypVar;  
...

meikl ;-)
0
 
JaymolAuthor Commented:
Meikl,

Just out of curiosity, why are you using ParamByName?  Is it okay to use .Clear with the Values array?

John.
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
JaymolAuthor Commented:
Actually, either way doesn't make any difference in this case.  I get the following error message when using the .Clear proc.

    "Variant does not reference an automation object"

o be perfectly honest with you, I could be doing this whole thing wrong as I've never used a TStoredProc before, but I don't think that's the case.

Any more thoughts?

John.
0
 
JaymolAuthor Commented:
That was it!  I just did it wrong.

I did this....


    StoredProc1.Params[3].Value.Clear;

which raise the exception.  If I now do this....

    StoredProc1.Params[3].Clear;

it works fine.  Now I'm just getting an error directly from the Stored Procedure which means that Delphi has passed everything correctly.

I appreciate the help Meikl, but if you've got any advice on using stored procs, or any suggestions as to usual pitfalls etc., I'd be very grateful for your help.

Thanks again,

John.
0
 
kretzschmarCommented:
well, jaymol,

first, glad that i helped you
and thanks for the points ;-)

and yes just ask if you have
problems with storedprocs,
i've used it a lot

why i use parambyname?
its just a safety issue,
because if the storedproc is changed
on the server by maybe inserted a param before or
reordering the params i will got allways the right parameter, where i have to provide or to get a value

well, if the parameter is renamed then i have also lost :-)

meikl ;-)
0
 
JaymolAuthor Commented:
Makes sense.

Thanks for the advice & help,

John.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now