Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[ancistrus]

Is there really no sane way to make a pl sql procedure write into a text file that is on my local machine?
I have spent 30 minutes googling and found nothing I can use.
My privileges dont even allow me to create tables so I cant use that as workaround.

The only thing I can do is select and I need to select lots of stuff
basically something like

for x in all_tab_columns
do various crap depending on other crap
execute immediate crap
write the result somewhere somehow....? (not sure if ctrlc from dbms output is a sane solution)

[TheBiggerFish]

And that's why you need typed languages!

No, it was int, int.  :v

[DragonDePlatino]

Then you make sure you change the types, so nothing compiles until you've corrected everything.

Huh, that's actually pretty handy advice! With Skyrunner's example of method(int, int) what's the best way to do that? Add a useless bool to the end of the method signature, then go through all the errors without adding the bool? Is there a better way to do that?

[Skyrunner]

If it's int, int then typed or untyped, no language can help ya.

[LoSboccacc]

^ what he said. while you're at it, you could aliasing int for what it really is (say, a coordinate? a priority value?) in the method so that moving forward the error can never happen again

[Rose]

If it's int, int, then you really should be asking yourself why it's so important to change it.

[miauw62]

This is why its good to have an IDE with a "search all" feature.  Or a small enough number of files you can ctrl + f them all in a timely manner.

oh, i had that. but i didn't realise that was the issue. because byond doesnt care if you pass 10 arguments to a function that only takes nine. i was rewriting a large part of code, but there was some other code that I *really* didn't want to touch, so it was basically a black box. i just thought i was getting the wrong output out of this box.

[TheBiggerFish]

If it's int, int, then you really should be asking yourself why it's so important to change it.

Readability.

[Rose]

Then, if you absolutely must, change the function name.

[LoSboccacc]

can also alias the type, depending on the language there are many ways to obtain talking parameters as needed.

[lethosor]

Then, if you absolutely must, change the function name.

If the function name was already sensible but the parameter order wasn't, changing the function name just to reorder the parameters won't help the situation.

If you want the compiler to flag all calls to that function for you, though, I guess that could be another temporary solution (besides changing the signature, removing the function, etc.).

[i2amroy]

This is why its good to have an IDE with a "search all" feature.  Or a small enough number of files you can ctrl + f them all in a timely manner.

I must say that the ability to simply right click on something and say "refactor" followed afterwards by "find all usages" is one of the biggest reasons that I use an IDE over busting out emacs/etc.

Heck, that's like one of the two main points of an IDE; to help you change things project-wide without breaking other things, and to catch you when you make stupid mistakes like using the wrong type/spelling variables or functions wrong. Everything else an IDE does is just sparkles on top of those two pillars.

[Parsely]

Well after a month of Wordpressing around on a website just tweaking design and fixing broken/empty webpages I've been unceremoniously promoted to admin of the successor site. I'm stunned. Am I doing it? Am I doing the thing?

[TheBiggerFish]

Well after a month of Wordpressing around on a website just tweaking design and fixing broken/empty webpages I've been unceremoniously promoted to admin of the successor site. I'm stunned. Am I doing it? Am I doing the thing?

You are doing the thing!  Grats BTW!

[3man75]

Hey guys, Im having an issue with elcipse where I deleted an old project in an attempt to start from scratch (it had problems with packaging for some reason).

Problem is that whenever I try to rename the project to what it was it says that theirs another project with that name. I know I can just rename it a bit different but i've gone on a warpath of sorts to complete destroy this 'original' that seems to be hiding somewhere. Somehow no matter how many times I go into my workplace folder and delete the 'new' project. After doing so I empty the recycle bin and go to name a new project with the same name but somehow it justs continues to say that a project can't be named that because theirs already one like it.

The cycle has gone for a couple minutes and I can't find where this file is located.

I'm using eclipse neon 4.6.0 and windows 10.

Anyone have this issue?