Shriek, hook, sh'bang...

There are times when the Internet can throw you a curved ball and you forget everything you learned - "...well it must be true, I saw it on the Internet".

I've recently (like, in the past four years) taken to programming stuff using a SQL Server database where things is slightly different from the Oracle bits I'd done since 1996.

Yesterday, I had a call from a guy in one of the manufacturing plants that still uses a very small portion of "my" old Oracle database.

"Um, we need to track product in a specific way so that we can witch-hunt the shift-crew who are damaging the pallets in transit..."

"Right"

I had a quick trawl through the old, existing code and couldn't find anything that did exactly what he wanted. So, rather than dig out the old Visual Basic (VB) compiler and create something consistent with what he used, I thought I'd knock up a very quick report using SSRS (SQL Server Reporting Services) - but, rather than using SQL Server, I'd "ODBC" into the Oracle database.

Simples?

Nope.

Well, writing the PL-SQL query was trivial, but I had to pass in the Pallet Number as a parameter. I tried the normal method "PALLET = @PalletNumber". And got "...missing expression".

Ah, I remember, you need to do something different for non-SQL Server. I Google'd for "SSRS passing parameters" and spent a good part of two days reading about how "easy it is" to "substitute the @ for a :" and how some twat called "Yisus Lopz" though it clever to add some completely useless entry about a SELECT statement at the end of every forum post I came across. 

All the report gave me was some damn error message about "...variable not bound" when I used the ":".

A colleague in the office heard me huffing and puffing.
"What's up".
"It's this bloody report, I can't get it to accept a parameter. In the good 'ol Oracle days, we just used to use a "?""



"Ah."



"That'll be it then."


(Note to confused readers, I've tried to make this informative and funny. I don't think I've succeeded in either).

Comments

Post a Comment

Popular posts from this blog

"The delivery extension for this subscription could not be loaded" when using SSRS

Image
OK, so we upgraded our server farm and put on the latest "stuff" (SSRS, SQL Server etc.) and the engineers gave me two servers to play with - SQL01 & SQL02. The idea being that we used high availability to help keep the factory running. We employed a contractor to load up and configure everything. At this point I wasn't involved. My involvement was to move all the reports and subscriptions from the old servers to the new ones once the servers had been configured. All went swimmingly, until I actually started to fire off the subscriptions to test them. Randomly (like 5 out of 10) I got the error in the title. I would edit the failing subscription and/or change the schedule time and it would work. I finally got around to moving 81 subscriptions for the same report (all slightly different parameters going to about 6 different engineers). I press the "go" button and every single one failed. Let's cut out the long story about how I went through about...
Read more

Oooh, look, an Eagle...

Image
The Scottish Holiday . After the trauma of the Astra-breakdown episode and the gutless hirecar, we'd recovered sufficiently to begin to enjoy the rest of our holiday with our friends at the Castle... Chapter Seven: One of the things my wife really wanted to see was a seal, or seals if she was really lucky. So we decided to take a day out and around the Mull Of Kintyre. We stopped at "St Columba's Footprints" and carefully studied the jumbled collection of rocks and seaweed. "No seals there dear, let's carry on" "Oh, alright then, never mind. But that's where we were told they are most likely to be." We drove on and took a gated road signposted " To The Lighthouse ". This took us right up into the hills. As we were driving slowly along admiring the view, my wife whispered quietly... " Ooh, look an Eagle! " "Stop that, that's not funny." "No, really. Stop the car." ...
Read more

What else could possibly go wrong?

So. I got the new radiator hoses from Vauxhall at a stupid £45 for the two and fitted them the weekend before we were due to go away on our Touring-Trip-Of-Scotland. I used this as an excuse to get out of helping with my sister-in-law's 50th birthday party. "But, I need to make sure the car is OK for next week dear!" "OK, I'll take the smart, and woe betide you if you're late for the party!" The Astra is now in bits and has no water in it. It is 6 minutes to 12 o'clock on a Saturday morning. I know this. For some bizarre reason, I decided to test the tightness of the -ve battery terminal by gently shaking the clamp. It was loose. "Ah, I wonder if this is the cause of it cutting out last week?" I took a 10mm spanner and gently tweaked up the bolt. The lead post (as in led, not leed) offered no resistance and gracefully detached itself in its entirety from the battery, the terminal now firmly bolted to the -ve lead (as in le...
Read more