Toad World® Forums

parameter passed to funcions/sps always go in lower case


#1

hi

i am using toad version 9.5.

when i pass any parameter to a stored procedure/function while executing same in toad.

always lower case is sent.

for e.g i have a parameter of type nchar to a function.

while executing it in toad parameter sent is ‘ShipGrp’.

but in function it is sent as ‘shipgrp’. (i saw using dbms output).

is this due to some property?

it only happens with toad works ok when i use sql plus or executre through jdbc.

shreyas