Recent content by hanchilicious

The title possibly makes this sound more intriguing a problem than it is. I just want to loop through a string, inserting spaces every other letter, so that instead of reading: THIS IS MY STRING it reads T H I S I S M Y S T R I N G I'm using CR2008 on Oracle 10. Thanks

Never mind, sorted it. :)

I meant to paste in the precursor to the handler: -- Return Results IF vCount = 0 THEN c_ResultSet := GetEmptyResultSet(''); ELSE OPEN c_ResultSet FOR SELECT House, Type, Title, SecondTitle, Channel, ValidFromDate...

Thanks Santa. I addressed this by adding an additional parameter to the function, to promote uniqueness. And whilst this seems to have resolved the 01422 error, now, the procedure returns 'ORA-01722: invalid number' when attempting to insert into a temp table. There is only one numerical...

To be fair, I think the 'distinct' included in both statements shouldn't let multiple returned values be an issue.

Okay, but how do I get the procedure to accept that there may be multiple values returned by the function?

Hiya, I get multiple line numbers flagged up. They're highlighted with --><--: 1) is from a function called by the proc: FUNCTION GetId(v_Item_id IN NUMBER) RETURN varchar2 IS strId VARCHAR2(50); BEGIN strId := ' '; ---> select distinct m.device_code into strId <-- ... 2) is from the proc...

Hi, I'm trying to run some pl/sql which is returning the above error. I'm not much of an oracle developer, and I'm just trying to resolve this issue in our programmers absence because it's an live problem. The bulk of the code is essentially populating the ListingData table below, but I think...

Strangest thing; that formula takes some tags out of their original order, and suffixes them to the end of the record, duplicating the original last tag. Also string values negate a carriage return prior to the next line. I'm running with: whileprintingrecords; stringvar qw :=...

Thanks, but the values can be any datatype as the data and title tags suggest. Plus, if there is no data, the output needs to reflect this to the user. created: 2008-05-12T14:06:19 episodeid: 112806 programmeid: 1150133 contentref: e.g. AB (for the sake of argument) episodetitle...

Propercase({field})

I really don't think writing a massive nested replace formula for strings which may or may not be there is the most elegant way to achieve this. I'm really looking to drive the bulk of the function from '<', '<>', or '</'. Cheers

Hi, Xtal XI How do you turn this one field (contains no carriage returns): <?xml version="1.0" encoding="UTF-8"?><qobject><type>QObjectVTIEpisode</type> <created>2008-05-15T14:06:19</created> <properties><episodeid>112806</episodeid> <programmeid>1105133</programmeid><contentref>...

Hi, I'm in a real panic here. I was running some procedures on my server, none of which were completing. So, after killing off some heavy processes on the server, and doing some general housekeeping, I rebooted the server. The procedures would still not complete, when before now, they would...

Brilliant. That's exactly what I was looking for. Thanks HarleyQuinn. PS: dig the name.