Sending a hash to a stored proc

vipinh has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Sending a hash to a stored proc by Anonymous Monk on Sep 25, 2000 at 21:15 UTC
It's very unclear what your trying to do. Are you trying to pass the hash keys and/or values as arguments to a stored procedure? Maybe you want something like: `$sqlstmt = 'EXECUTE TestProcedure ('.join(",", values %hash).')'; Or to quote the values: $sqlstmt = 'EXECUTE TestProcedure ('.join(",", map {"'".$_."'"} values + %hash).')';` [download] That will give you an unordered list of the hash's values, which is unlikely to be what you want. If you need more help, you'll have to be more explicit about what you're trying to do.	[reply] [d/l]
Re: Sending a hash to a stored proc by JanneVee (Friar) on Sep 24, 2000 at 20:39 UTC
The question is quite unprecise... How do you try to pass the hash to the exec call? /JanneVee	[reply]
RE: Re: Sending a hash to a stored proc by vipinh (Novice) on Sep 25, 2000 at 04:14 UTC
Hi, I use the Win32::ODBC , and use the SQL function like this $sqlstatement = "EXECUTE TestProcedure " . hash-name $db->Sql($sqlstatement); i also tried using the Run function instead of the Sql function, but no difference What am i doing wrong ? Does Perl not supprt connecting to Microsoft SQL Server 7 ?	[reply]
Re: Sending a hash to a stored proc by Fastolfe (Vicar) on Sep 26, 2000 at 20:20 UTC
The error is consistent with an undefined object reference: `$object->method(@arguments);` [download] If $object is undefined (if this were a database handle, I'd check to be sure the connection succeeded), you will receive an error message saying "Can't call method 'method' on an undefined value..." Since we're almost certainly talking about a database handle, I would examine your code around the area in question (or where that code is being called in your own code) and be certain that the object you're passing is defined.	[reply] [d/l]