Search results for query: *

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...

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'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...

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

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...

Hello, once again rather than giving a proper problem I've got one about performance/security. If I'm selecting a number or columns using a cursor and then wish to pass those column values, as well as other values, into a table(well, table encapsulation package), should I call the procedure...

Hello, I was just trying to figure what was the best thing to do with the following scenario. I have a cursor for loop. Inside the loop I need to access a couple of other cursors which will only ever have one row but that row changes each time round the cursor for loop. Should I open and...

Hellooo! I'm trying to create a table in a piece of sql and wanted to make sure that the table's one column is definitely the same as a column in another table that is already created. For this end I thought I could use the following syntax: CREATE TABLE temp_asns(asn_asn_id asns.asn_id%TYPE)...

Hellooo, I was just wondering on the benefits of having a Primary Key as well as a unique index in a table. I know that when you create a Primary Key, a Unique (Clustered <- which I'm not sure what this is) Index is automatically created so the Key can be enforced. According to this thread...

This is partially connected to the folowing thread707-659257 , click to read what I'm actually trying to achieve! The only problem I have with this code now is that when it runs I get the following error: GetText Invalid FORMATETC structure And the line highlighted is the line marked red...

Hi, Got a right old problem here and have been racking my brain but cannot come up with an answer, or at least an answer I can code! I currently have some code which moves a button about on a spreadsheet to be in line with whatever row is selected. See here: Private Sub...

Hello, I have a word document in which I want to account the occurences of certain patterns of text such as &quot;PW&quot;, &quot;DW&quot;, &quot;MH&quot; etc. I want the results displayed on a webpage so I figured since the machines this will run on don't have perl installed that javascript...

I've been given a database to work on and being brand spanking new at oracle I can't find where the list elements for a poplist are. I looked in the property palette for the poplist, clicked on 'Elements In List' and was given a program error written in one row of the list and nothing else...

I've a small piece of code that doesn't like me referencing a table directly but when I use an alias it's fine: SELECT ret.RP_ID, SHORT_DESCR, RP_RP_ID_ARTL FROM RETL_PRDS ret WHERE ret.RP_ID = TEMP_SCODES.RP_ID OR ret.RP_RP_ID_ARTL = TEMP_SCODES.RP_ID ORDER BY ret.RP_ID; doesn't work but...

Hey everybody, Does anyone know where I could get a listing of objects used in the VBA of Access 97 which are not used in the VBA of Access 2000? Specifically, I can't seem to use Printer.ScaleMode or Printer.ANYTHING in my code and I'm assuming this is because it's obsolete. Cheers, Pete

Hey, I am currently have a crosstab query which shows training courses down the side and employee's surnames as column headings. The value in the cells is the status: &quot;Completed&quot;, &quot;Needed&quot;, &quot;Booked On&quot;. If an employee is not related to a certain course, then a...

Quite simple, the subject line! Can it be done, or is it impossible? Cheers, Pete