Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: TSqlStoredProc with overloaded StoredProcName: how to pick which overload?



Permlink Replies: 0
Warren Nielsen

Posts: 1
Registered: 2/3/02
TSqlStoredProc with overloaded StoredProcName: how to pick which overload?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 22, 2018 10:09 AM
Using Devart's dbexpress driver for oracle in client mode.

spr:= TSQLStoredProc.Create(nil);
spr.SQLConnection := SQLConnection;
spr.PackageName := 'PACKAGE';
spr.StoredProcName := 'PROCEDURE1';
spr.ParamByName('pUsername').AsString := 'E';

This procedure has two overloads. One has pUsername, the other doesn't.
The last line gives me a parameter not found. I can't find anywhere how to pick which stored proc it picks up. I found a few questions google searching, but no answers. Anyone here know the trick?

Edited by: Warren Nielsen on Jan 22, 2018 10:35 AM
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02