@Phil and calling the function causes: ORA-28575: unable to open RPC connection to external procedure agent ORA-06512: at "CALL_C_PROGRAM", line 1 ORA-06512: at line 5
@JackDouglas i mean, definitely use a real VPN if you got it. But SSH tunnels work in a pinch. I don't think I've ever had the need to keep it around permanently
@JackDouglas i've never personally heard horror stories of SSL, but there's definitely been security patches around it - meaning there definitely were issues
@myusuf3 you haven't really explained why your next step isn't a move to AVPC - I'd like to know why you don't want to do that right now and save yourself all this trouble?
@Phil shrug I don't know, I just haven't heard great things. And I'm not real excited about picking it up as they're trying to transition stuff to it and while me transitioning into the admin role.
Was on a migration project a few years ago & a load of ETL stuff needed redoing to take output from our new stuff. Had to work with a Teradata consultant to do data mapping etc - was an utter nightmare (I knew the source system very well, he didn't know the destination system, but it was his job to do the data mapping). Would've been easier to send me on a Teradata course or just let me mess with it for a bit and talk to the techies that knew the target data model
I was a business analyst in my first job (for my sins), so I know how to turn thumb screws to get info :)
I am modelling a database for an application I am developing and I am in front of choices for which I would like to know what the best practices are.
Let's say I have a Documents table and a Users Table. Users can be related to documents different ways: be the owner/creator, a document can be about a user but invisible to the user, or a document can have been made visible to a user.
I could model a Many-to-Many relationship with a table containing a DocId field, a UserId field, and a Status (Owner, Visible, or Invisible). The good thing about modelling things this way is that everything I…
@Phil Well, I decided to post it here after reading the FAQ where they say not to ask open ended questions on the site... So I am not sure where is the place for such questions open to discussion.
@Phil I removed the (PROGRAM = extproc) from listener.ora
@Phil but now I cannot run my extenal proc!!! it says: ORA-28575: unable to open RPC connection to external procedure agent ORA-06512: at "CALL_C_PROGRAM", line 1 ORA-06512: at line 5
@Jean-FrançoisBeauchamp If you have a finite set of those statuses (i.e. the three you've defined) I'd add an attribute to the document for each of them
I would like to use code that I developed in C Sharp CLR to be used in all of the databases on the system so that I don't have to set each to trustworthy and turn CLR on and keep a bunch of the same code inside each one.
Is there a best way to do this from an administrative and security standpoi...
@MarkStorey-Smith I am not sure of what kind of attribute you meant... Ok, I'll post my question on dba.se. However, I am getting this warning when typing my question there: "The question you're asking appears subjective and is likely to be closed."
I did some research and found some good information. The following is a direct quote from a primary source:
When SQL was first invented, it had no aliases in the SELECT clause.
This was a serious shortcoming that was corrected when the language
was standardized by ANSI in about 1986.
...
Can an IEEE-754 floating point number < 1 (i.e. generated with a random number generator which generates a number >= 0.0 and < 1.0) ever be multiplied by some integer (in floating point form) to get a number equal to or larger than that integer due to rounding?
i.e.
double r = random() ; ...
@JackDouglas I think the appropriate thing here is that I'm really looking to reduce global usage and instead implement methods so that the behavior can be contained later, if need be. I think that's the right idea, anyways.
somewhat of a separation of concerns, since I don't think I can do full blown classes in a scripting language and have it make sense
@MarkStorey-Smith But you can figure out who it is since Raymond F. Boyce of Boyce-Codd Normal Form died and is thus unavailable for interview. It's not Codd.
@JackDouglas yes, because a) the script uses a lot of includes, and b) the script is over 12 files with over 1200 lines of code all told, and that's with me having already gone negative code over the past few days.
Huh, learned something new, the assembly does go with the database. I could have sworn back in 2005 I needed to copy the DLL and deploy / register on the new server when I moved a database.
@JackDouglas Looks like it's guaranteed for reasonable integer scaling. For very large (cosmic) integers it can fail because the integer won't convert to a float exactly.
What is the difference between SSH and SSL? Which one is more secure, if you can compare them together?
Which has more potential vulnerabilities?
I did some research and found some good information. The following is a direct quote from a primary source:
When SQL was first invented, it had no aliases in the SELECT clause.
This was a serious shortcoming that was corrected when the language
was standardized by ANSI in about 1986.
...
Can an IEEE-754 floating point number < 1 (i.e. generated with a random number generator which generates a number >= 0.0 and < 1.0) ever be multiplied by some integer (in floating point form) to get a number equal to or larger than that integer due to rounding?
i.e.
double r = random() ; ...
