Forum Discussion

Copper Contributor

Nov 07, 2018

Oracle SQL DB with Powershell

Hi All, I made this script for a client of mine, But I am now trying to make it more intelligent by adding conditions, ie. If statements/Switch But I am hitting that "System.Object[] cannot be Int32 ...

Windows PowerShell

Sean Kearney

Former Employee

Nov 20, 2018

One of the things is to identify which lines are producing the Errors.

You could pop this in PowerShell ISE *or* Vscode and run an individual trace on each line.

The other part is to run each individual line in PowerShell (Good only Copy/Paste will work) and show which line is producing the "System.Object" output.

Once you have that you can try piping that line into Get-Member to see the Object type and properties. Not knowing the Object I can't comment yet on how to pull the pieces you need out. But if we can fix the first problem, the rest could be easier to solve or might even just clear up

Let me know how I can help!

Sean

David Lay

Copper Contributor

Nov 20, 2018

Hi Sean,

I did use the "get-member" and its shows as an object, despite I ended up making a working solution by running a {if} that compare string as string with a predefined string, given that the output was sent to a webhook as a string.

Thanks though, I did tried using SQL end, but its does not do what I expected. As a result $string -match does the job.

Thanks