ODAC 6.05 : Torastoredproc parameters not showing up

wchris · Post by **wchris** » Thu 07 Jun 2007 11:48

Hello,

We set up a machine to test our application with ODAC 6.

we use many stored procs.

With ODAC 5 removing the StoredProcName value cleared the parameters.
Putting back the StoredProcName value forced ODAC to read again the parameters when clicking on Params.

This is broken in ODAC 6 and is not working anymore. The only way to get the parameters is to clic "execute" in the Params window. but then the OUT fields are no more null and the output values are stored in the DFM.

Thank you for investigating this issue

Plash · Post by **Plash** » Thu 07 Jun 2007 13:43

In the next ODAC build we'll add the 'Create SQL' button to the TOraStoredProc editor. This button can be used to recreate stored procedure parameters.

wchris · Post by **wchris** » Fri 08 Jun 2007 09:28

Good idea

i agree

Thank you

wchris · Post by **wchris** » Fri 06 Jul 2007 12:09

Hello,

I'm now running ODAC 6.10.0.9

but i can't find the 'Create SQL' button in TOraStoredProc design-time editor.

ODAC revision history tells : Added 'Create SQL' button in TOraStoredProc design-time editor

Do you actually see the button ?

Challenger · Post by **Challenger** » Sat 07 Jul 2007 14:45

You can find the "Create SQL" button right after "Overload" splitter in the top right corner of the window.

wchris · Post by **wchris** » Wed 11 Jul 2007 14:57

Challenger wrote:You can find the "Create SQL" button right after "Overload" splitter in the top right corner of the window.

Oh yes thanks ! found it. I was searching in the parameters panel for a button with 'create sql' written on it. because when you click 'params' in the object inspector you get directly there.

Maybe the button shoud be visible in the parameters panel when the params list is empty ? not sure, just an idea.