Is there a statement that can drop all stored procedures in MySQL? Alternatively (if the first one is not possible), is there such thing as temporary stored procedures in MySQL? Something similar to temporary tables? So far, for both tasks, I seem not to find any answers although there were people asking for those in other forums. Than...
This question is a follow-up of the post at http://stackoverflow.com/questions/3171332/ada-file-operation-instantiation-and-exception about writing to files in Ada. I chose to place this question in a separate post so that it'll become visible to more people as I already accepted an answer on a slightly different issue (which was on ...
Possible Duplicate: A good reference for Oracle PL/SQL I need make a procedure to fill some tables in oracle, i'm new in oracle, i need receive two ids, with that make a couple of loops, iteratos, or something like that, and then make a few of sql, the procedure will be called into a trigger, but i can't find a good and comple...
Why is this the case? I was using simple text queries and it worked well. When I turned those queries in stored procedures, it does the job, but listviews and gridviews dont update/refresh automaticly. Help please. ...
I am trying to generate a set of rows for a matrix but the @xcolcount only does on loop staying at zero while the inner loop does what it needs to: Declare @xColCount int Declare @yRowCount int set @xColCount = 0 set @yRowCount = 0 WHILE (@xColCount < @widthCol) BEGIN WHILE (@yRowCount < @heightRow) BEGIN -- do the i...
hi there, we're currently executing a stored procedure ( ms sql 2008 ) from axapta ( ax 2009 ). the sp is indeed quite large and the obfuscating effect is, that the sp doesn't work, if triggered via odbc. a simple "exec sp ..." executed via ssms works fine. if we remove some of the last queries executed in the sp, the sp also works fire...
I use Madshi's madCodeHook components to Inject a DLL in a process, and then hook a procedure/function. The problem is each time a new version of the EXE comes out the address of the functions may change. Currently the way I do it is to use Ollydbg and then hard code the address in the DLL that I inject into the process, this is very u...
Hi, I'm having some problems with my stored procedure. Hope anyone can help me figure out what the problem is. I use the data from weekly_schedule as a template for how fill my flight-table. I do this by calling CreateFlights(). All data get inserted as expected, so I'm not missing any data, but for some reason every third row is skippe...
Hello. I have a class (TExample) and I want to have an array of pointers that point to TExample methods. For example, I'd like to have TExample.ThinkOne and do aPointers[1] := @TExample.ThinkOne or something similar. How can I properly do this? Thanks. ...
I am passing null to below procedure as below its is not returning any values even if data is there in the table? call view_ads (NULL,'vehicles',9); call view_ads ('placename',null,9); ===================================================================================== below is the code delimiter $$ drop procedure view_ads$$ create...
Hi all, I searched a lot, but couldn't find anything.. I just want to ask if there's any way to create and call a procedure (Informix) with out parameters. I know how to return one or more values (for procedures and for functions), but this is not what I want. It would be really strange, if Informix does not allow output parameters.. ...
This should be an easy one for someone... I had a function in a TCL script called unwrap. Modifying it, I realized I no longer needed to pass it args. So I changed it to unwrap {} { ... } Now when I call it with no args, i.e.: unwrap I get an error invalid command unwrap Ideas? How do I properly format a TCL function with no a...
So I am very new and inexperienced to the ways of TCL programming. I wrote a script that calls a proc written by someone else, first removing the output file. It then does some additional logic I wrote. I moved the logic into a second proc and instantly a bunch of it broke (namely the rm commands). From what I can tell, the first prog...
I have 2 procedures (A,B) in Oracle 9i. In individual, they all work fine. But I cannot make a procedure C that calls A, which in turn calls B. I put a dbms_output.put_line before C calls A, before A calls B and one in B. Somehow, only the first put_line works. What are the possible reasons why this doesn't work? Thank you, CREATE OR RE...
Hello - I have this problem where I need to set "optional" parameters for my stored procedure to work fine. For example, I have this: CREATE PROCEDURE [dbo].[Search] ( @StartTime datetime = NULL, @EndTime datetime = NULL, @CustomerEmail nvarchar(255) = NULL, @OrderStatusID int ) Now, in my .net website I have this like an exampl...