Search results for query: *

I did have that as an option, just thought it might be a bit overkill to create an array(of sorts) for something so simple. jaggiebunnet: Yes, I was trying to append the loop variable to the variable name and then look at the result as if it was a variable. Cheers for the suggestion about...

Yeah, the variables have already been defined. Basically they're each a running total from a FOR loop that happened before this LOOP so when you get to this point, some of them will have a value of 0 and others will have a value greater than 0. CREATE OR REPLACE PROCEDURE HSP_EXT_DIDOS_PO IS...

Bugger! Cheers for letting me know Dima, don't really know how to utilise your alternative suggestions with what I want to do though. I've basically got 7 variables(variable1 to variable7) and I want to do a similar thing to each but need to check that the value of the variable is greater than...

Hi, I'm trying to find out whether PLSQL has an escape character to indicate that the text following it should be taken as a literal. To explain: I want to use the following statement: DECLARE variable1 VARCHAR2 := 'a value' BEGIN IF variable || '1' = 'a value' THEN The way this reads...

Cheers for that Dima, I got an answer off MetaLink earlier on which went into detail on the whole scope thing with the SQL Engine for the cursor etc. etc. and have now managed to test it with a dummy procedure trying to reference a local variable from a cursor and it failing. Also worked out...

Cheers for all this Dima, I did a search through hsp_ext_didos_corp and found no other hsp_supp_type functions or otherwise. Pretty sure there is no hsp_ext_didos_corp user but had a search through the users table and came up with nowt. What suggests most to me that the line in the cursor is...

Right, Oracle is 8.1.7.4.0, just noticed that I posted this in the 9i forum so if anyone has the power, would be good if it could be moved, sorry about that! I noticed I used the phrase "main program" in my original post, what I meant by that was the main procedure. This function is defined...

Cheers Dima, I've already looked for that possibility and couldn't find any other functions called hsf_supp_type. Also tried doing a Describe and nothing happened. I know that my procedure is looking at my "private" function because if I comment the function out then I get an "hsf_supp_type...

Thanks everyone for that, and there was me thinking there wasn't even one way!

Hello, I have an interesting twist on the ever loved PLS-00306 wrong number or types of arguments in call to ... error! I have a stored procedure which amongst other things, has a function defined inside of it. Cut down version is like so: CREATE OR REPLACE PROCEDURE hsp_ext_didos_corp (...

Hello again! Does anyone know how to return an entire file apart from the first line? Like using tail? So I have a file: 1233 125457 123214235 213123 and I want the following returned: 125457 123214235 213123 Cheers,

I've just noticed that the option -m might be what I'm after but I don't seem to have it with my version of grep. Bugger!

I'm pretty sure there isn't an option on grep but can anyone think of a way to only return the first matching line that grep finds? Cheers

Hello, I have a procedure with a number of formal parameters where the actual parameters I pass in are PL/SQL table columns. I wanted to know, if I make some of the formal parameters IN OUT parameters, will the PL/SQL table columns get updated when the formal parameters are changed within the...

Sorry, what I meant was that in the record group, I was recording the row id whenever you insert a row with certain data. Like you say, since the row id's change, this isn't a viable way of doing it. I've pretty much done what you've suggested and started recording the data and matching against...

Hi Lewis, Thanks for that, it does seem to be the way forward. The problem now is that if you delete a row from the block, any rows with a greater TRIGGER_RECORD than the row just deleted, have their TRIGGER_RECORDS decreased by one. So if there were two rows that I had recorded in the record...

Hi, I'm using Oracle Forms 6i. I have a form with 3 blocks on it. Like so: _____________ | BLOCK 1 | |_____________| |BLOCK2|BLOCK3| |______|______| In block 3 I have a text item which repeats down indefinitely with a scrollbar to the right. Whenever I insert a new row into...

Hi, Using the syntax ACCCEPT variableName PROMPT 'How many of whatever would you like?: ' Is it possible for a default value to be displayed so the user can just press return to accept it? So the prompt would look like: How many of whatever would you like?: DefaultValueHere Cheers, Pete

I think it's going to be a re-install cos the htm, html file types etc are definitely associated with the browser that I use so no clues there! Cheers for your help

Hello, Having recently installed Dreamweaver MX on a friends computer, now when they press F1 in Adobe Photoshop, Dreamweaver attempts to load the help files. This happened in a couple of other programs as well, Dreamweaver tried to open the help files. I had a look at file types and CHM and...